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 db2 400?
Explain packages.
How can you do the explain of a dynamic sql statement?
What is db2 plan table?
What is a buffer in memory?
What do you mean by commit and rollback?
what is diffrence b/w file-aid tool and file-aid utility???
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is precompiler in db2?
What are the bind parameters ibm db2?
Mention the downsides of page level lock.
What are the contents of a dclmgen?
What are bind parameters in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the clustering index in the db2 database?