which authority can be granted to group of users using the GRANT stmt?

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2

Question

which authority can be granted to group  of users using the 
GRANT stmt?
A)	SYSCTRL
B)	SYSADM
C)	DBCTRL
D)	DB ADM

Question Submitted By :: Harish

Rank

Answer Posted By

Re: which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

Answer
# 1

(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 ?

0 Yes

0 No

Nickyhuang

Re: which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

Answer
# 2

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 ?

1 Yes

0 No

Shweta

Question	Asked @	Answers
Other DB2 Interview Questions


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?		2
What is the format (internal layout) of ?TIMESTAMP??		1
What is DCLGEN ?		2
Which transaction use a command thread ?		1
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.	Cap-Gemini	4
How many sub queries can you combine together ?		4
How many clustering indexes can be defined for a table?		1
What is correlation names?		1
Is it mandatory to use DCLGEN? If not, why would you use it at all?		2
What are the 4 environments which can access DB2 ?		2
what types of copies can be made with the COPY Utility ?		1
What are the disadvantages of using VARCHAR?		3
What is a host variable?		1
What are PACKAGES ?		3
How will you delete duplicate records from a table?		3
What is the self-referencing constraint?		1
What is isolation level?		1
What is RUNSTATS?		3
Explain an outer join?		1
What is Reorg Recovery? when will you run it?		1

For more DB2 Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com