which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM

Answers were Sorted based on User's Feedback



which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C)..

Answer / nickyhuang

(D)Database level authorities, DBADM and LOAD, are granted
to a user or a group of user by the GRANT statement; SYSADM
grant/revoke DBADM.

Is This Answer Correct ?    3 Yes 0 No

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C)..

Answer / shweta

SYSCTRL and SYADM can be granted only to groups while
DBCTRL and DBADM can be granted to both users and groups.

Is This Answer Correct ?    3 Yes 0 No

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C)..

Answer / mehdee

- All the above group are Data Base Admin. they are not
users. The following are the type of grant to users:
GRANT SELECT ON TABLE
GRANT DELETE ON TABLE
GRANT BIND,EXECUTE ON PACKAGE
GRANT UPDATE ON TABLE
GRANT INSERT ON TABLE
GRANT ALL ON TABLE

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is the result of open cursor statement?

0 Answers  


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


What is ibm db2 used for?

0 Answers  


What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  






What is COPY PENDING status?

6 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


How do you define a correlated name?

1 Answers  


Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  


What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  


Is db2 a programming language?

0 Answers  


How would the varchar column remarks defined?

0 Answers  


Categories