which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
- 3 Answers
- 9285 Views
- Accenture, I also Faced
- E-Mail Answers
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 is the role of the data page in the db2 database?
What are the bind parameters ibm db2?
What is check constraint. Explain with example.
What is a page in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How can record locking be achieved in those DB2 versions which do not support it?
What is with ur in db2?
List out the buffer pools in db2
What is schema in db2?
What is ibm db2 database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the function of logging in the db2 database?
What is sqlca’s maximum length?
What is explain plan in db2?
What are bind parameters in db2?
