Interested to Buy Any Domain ? << Click Here >> for more details...
which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
- 3 Answers
- 9988 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 cursor in dbms?
Name the various locking levels available?
Discuss about db2 bind?
Explain what are the various isolation levels possible?
What os does db2 run on?
What is role in db2?
What are concurrency issues?
Before you give the explain statement, what are the prerogatives?
What is dbrm? What it contains?
What is the use of commit in db2?
What is the role of union all and union
How is a typical db2 batch pgm executed?
What are the benefits of using the db2 database?
What is innodb buffer pool?
What do you mean by rollback?
