which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
Answer Posted / 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 View All Answers
What are the rules for db2 programming?
Explain the contents that are a part of dclgen.
How do I start db2 in windows?
What is a bind in db2?
Which components manage deadlocks in db2?
What is the use of value function?
What is check constraint in db2?
define clustering index.
Describe major components of db2?
Explain in detail about buffer manager and its functionalities?
List some fields from sqlca?
What is the difference between using bind () and rebind () methods of naming class?
What is role in db2?
What db2 400?
What is the difference between plan and package in db2?