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
- 9862 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nickyhuang
(D)Database level authorities, DBADM and LOAD, are granted
to a user or a group of user by the GRANT statement; SYSADM
grant/revoke DBADM.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shweta
SYSCTRL and SYADM can be granted only to groups while
DBCTRL and DBADM can be granted to both users and groups.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What are the full forms of spufi and dclgen and why are they used?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the function of logging in the db2 database?
what are stage one indexable predicates?
What is a view? Why use it?
What is dclgen in db2?
What is the physical storage length of the data types date, time, and timestamp?
How to insert more than one record using insert?
What is the difference between CS and RR isolation levels?
What's the maximum number of characters that a tablename can have?
What does the REORG Utility do?
COBOL 
