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 size of a data page?
Where could you look if you had a question about whether a column has been defined as an index?
What are common abends
cobol-db2 runjcl please?
What are the abend codes occour in ur latest PROJECT in DB2
What is precompiler in db2?
What are the various locks available?
What are the 2 sqlcodes that are returned?
What is dclgen (declaration generator)?
Explain about open switch business continuity software?
When do you specify the isolation level? How?
Can any one tell me about Restart logic in DB2.