ca.portal.admin

Re:Re: [IDMSVENDOR-L] Question about adding a user to a group

Discussion created by ca.portal.admin on Jun 22, 2010
kay - when added thru the ALTER USER - the group you specify is treated as
the DEFAULT group for the user - the the association is made thru the
ALTER GROUP - no such ""fdefault"" status exists

what that means i do not know - but that is the difference (I believe)


Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
06/22/2010 01:27 PM
Subject:
[IDMSVENDOR-L] Question about adding a user to a group
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



When a user is added to a group with the ""ALTER GROUP"" command, the group
s=3D
hows in the user display as ""WITHIN GROUP group-name"".

But if the user is added to the group with the ""ALTER USER"" command, the
gr=3D
oup shows in the user display as ""GROUP group-name"". Unless you add the
us=3D
er to a second group that way - then the first group is changed to ""WITHIN
=3D
GROUP"", and the second group displays as ""GROUP"".

Do these two methods of adding a user to a group actually do the same
thing=3D
, or not?

The reason I am asking is because in Visual DBA R17, you can add a user to
=3D
a group from the same screen where you create or alter the user. This
woul=3D
d save time, rather than having to navigate through the ""display group""
scr=3D
eens first. But it appears that doing it from the user screen is using
the=3D
""CREATE USER"" or ""ALTER USER"" commands under the covers. And I'm not
sure=3D
if that accomplishes the same thing as adding the user to the group with
""=3D
ALTER GROUP"".

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov



The information transmitted is intended only for the person or entity to
wh=
ich it is addressed and may contain CONFIDENTIAL material. If you receive
=
this material/information in error, please contact the sender and delete
or=
destroy the material/information.



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Question about adding a user to a group
"=B7 You can add a user to a group in one of these ways:=20
=20
- Using the GROUP parameter of the CREATE/ALTER USER statement.=20
=20
This specifies the user's default group. Only one group can be=20
specified.=20
=20
- Using the ADD USER clause of the CREATE/ALTER GROUP statement.=20
=20
You can add the user to any number of groups in this way. You=20
must first create the user.=20
=20

Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly=20






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
06/22/2010 02:26 PM
Subject:
Re: [IDMSVENDOR-L] Question about adding a user to a group
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



The default default group (no, that was not a stutter) is PUBLIC. Does=20
tha=3D
t mean that if you specify a default group other than PUBLIC, then the=20
user=3D
is not a member of PUBLIC?

Outcomes