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
How can you classify the locks in db2?
How do we specify index to include or not during bind process.
How to find schema of a table in db2?
How do I import a csv file into db2?
How to view db2 table structure?
What is a db2 package?
What is the purpose of using commit?
What is the difference between nvl and coalesce?
What is the use of reorg in db2?
What are the uses of db2 optimizer?
Define check constraint.
What is meant by dclgen?
What does db2 plan contain?
What is db2?
Is it possible using max on a char column?