DB2 instance -users
Hoefgetrappel
He has total ownership of the instance, and all the databases in it.
Is it possible to have multiple users for an instance or even one database
in an instance?
Is it possible to have users with less privileges?
Thanx
Ben
Sivakumar Shanmugam
instance is created...So there will be only one owner for an
instance..Yes we can have one db per instance..To have multiple users
to own the database add their user Id's to SYSADMIN group of the
database...or give DBADBMN privileges to the users...This way multiple
user will be able to mangage the database...To have users with less
privileges grant only the required privileges on db to the users....
Hope this helps...
Sivakumar shanmugam
"Hoefgetrappel" <hoefge...@pandora.be> wrote in message news:<dAOh8.64490$Wc1.180...@hestia.telenet-ops.be>...
Shiva
users to a GROUP and update the group in DBM CFG.
$db2 update dbm cfg using SYSADM_GROUP groupname
$db2stop
$db2start
2. You can have as many databases as you want in an instance. But all
the users in SYSADM_GROUP will have SYSADM authority on all the
databases in that instance.
3.YES...it is possible to have less priviliges by granting only the
required priviliges to the user or by revoking unwanted priviliges
from the users.
for more information, it is better refer to Administration guide.
>
> Thanx
>
> Ben
Michael Tiefenbacher
jssiv...@hotmail.com (Sivakumar Shanmugam) wrote in message news:<787a0281.02030...@posting.google.com>...
> The instance Owner ID is nothing but an Unix userId through which an
> instance is created...So there will be only one owner for an
> instance.
This is true just right after the instance creation.
YOu can update the DBM CFG and set a SYSADM_GROUP after that
restart the instance and every memeber of the SYSADM_GROUP will
have the full SYSADM rights - that means full access in the instance
So take care!
>.Yes we can have one db per instance..To have multiple users
> to own the database add their user Id's to SYSADMIN group of the
> database
no - of the instance - as described above
>...or give DBADBMN privileges to the users...This way multiple
> user will be able to mangage the database.
There is also a SYSMAINT_GROUP ans SYSCTRL_GROP configurable
in the dbm cfg (Instance configuration) with fewer rights
than the SYSADM.
Have a look at the manuals!
Attention the DBADMIN right is also granted to the users.
Attention: granting DBADM and revoking it afterwards
will leafe some (non standard rights) for the user.
>..To have users with less
> privileges grant only the required privileges on db to the users....
> Hope this helps...
> Sivakumar shanmugam
Michael