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 SQL Communications Area and what are some of its key fields?
Where is the access path logic created by the DB2 Optimizer stored?
What is dclgen (declaration generator)?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How do you do the EXPLAIN of a dynamic SQL statement?
Explain dclgen.
How do you define a correlated name?
Which catalog table stores referential constraints?
What is a buffer in memory?
What is PRIME TABLE and what are the uses of it
What do you mean by commit and rollback?
What is the use of DELGEN in DB2? Can we Write the program with out using it?