SYSADM privileges? How to assign?

Jan M. Nelken · *nix forums Guru Wannabe Joined: 26 May 2005 Posts: 126

Thiru wrote:

Thiru · *nix forums addict Joined: 20 May 2005 Posts: 80

Hi,
I want to assign SYSADM privileges to user say XYZ. I know that this
privileges can't be assigned directly using grant command. But can be
acheived by assigning the privileges to group and then inturn assign
the user to the group? Does this group mean OS level group or something
else? plz tell me how to do that?

For Your Information
--------------------

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08010"
with
level identifier "01010106".
Informational tokens are "DB2 v8.1.0.36", "s021023", "", and FixPak
"0".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

OS: Win 2k Professional

I come across this question while preparing for DB2 701 exam.

Thanks,
Thiru
WantedToBeDBA

Google