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

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

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


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?		2
When Can you be sure that a query will return only one row?		3
What is JOIN and different types of JOIN.		2
What's the maximum number of volumes that can be added to a STOGROUP?		1
When is the access path determined for dynamic SQL?		2
What is UNION,UNION ALL?		1
What is a cursor?		2
What does the RUNSTATS Utility do?		4
When is the skeleton cursor table created?		1
Are views updatable ?		3
What is cursor stability?		1
What is the difference between TYPE 1 index & TYPE 2 index		1
What do the initials DDL and DML stand for and what is their meaning?		2
how can u understand the end of the table ?	TCS	1
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM	Accenture	2
pls explain the precompilation process of cobol-db2 pgm	IBM	1
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?	Wipro	5
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?		1
What is an access path?		2
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?	Tech-Mahindra	3

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