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
- 9859 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 will you delete duplicate records from a table?
What is consistency token in db2?
what is the use of cursors?
What is COPY PENDING status?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
what is a collection?
What is the maximum No of rows per page?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Mention the different locking levels that are available in db2.
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What are the uses of db2 optimizer?
COBOL 
