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
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 |
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 |
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 |
What is the result of open cursor statement?
What's The Error Code For Unique Index Voilation?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is ibm db2 used for?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is COPY PENDING status?
What's the maximum number of volumes that can be added to a STOGROUP?
How do you define a correlated name?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a NULL value? What are the pros and cons of using NULLS?
Is db2 a programming language?
How would the varchar column remarks defined?