DB2 uses operating system users and groups only. So you will have to
create users and groups at the operating system level.
You can associate an operating system group with either one of SYSADM,
SYSCTRL or SYSMAINT authorities using the command
update dbm cfg using SYSADM <grp name> .
Here the group name is the operrating system's group name.
These are at the instance level.
At the database level you have DBADM authority. The creator of the
database gets the authority implicitly. For other users, you can use
the GRANT SQL statement.
Hope this helps.
> Hi, all.
> When i installed my Db2EE i have only one user(administrator).
> I want to create users with for example SYSDBA or SYSCTRL
> authorities. Or another users, for example ordinary users.
> How i can do it?
> Must i first make users and after give them authorities?
> (it for users with SYSDBA or SYSCTRL authorities)
> thank you.
Sent via Deja.com http://www.deja.com/
Before you buy.