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

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

Question Posted / harish

3 Answers
9974 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

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

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

Post New Answer