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
- 9969 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 |
What is collection in db2 bind?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is the FREE command?
Where could you look if you had a question about whether a column has been defined as an index?
What does it mean if the null indicator has -1, 0, -2?
How would one remove old reorg information from the DB2 catalog?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are catalog tables in db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is copy pending status in db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is DCLGEN ?
COBOL 
