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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between db2 and oracle?

866


What is syscat in db2?

772


What is the physical storage length of time data type?

883


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

846


Mention the location where the output received from explain statement is stored.

844


Is it possible to create an Instance in DB2 using DB2 Control Center ?

837


How many databases are there?

771


How to check sequence on a table in db2?

799


What is query_cache_limit?

744


What is universal database?

827


What is the maximum number of columns in a db2 table?

976


Why do chiropractors use drop table?

872


What is collection in db2 bind?

768


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8291


Discuss about db2 bind?

859