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
- 10007 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 |
wht r the requirements for writing a cobol-db2 pgm ?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What is lock escalation in db2?
How do you Load a table ?? and what is Load replace ?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is a correlated sub query?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is a DBRM, PLAN ?
What is db2 look?
When is the access path determined for dynamic SQL?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Highlight all the advantages that are attached to a package.
COBOL 
