-
privileges to connect role
Hi,
From which dictionary table, I know which are the privilges has been granted to connect or resource role?
Thanks
Nwcomer
Student
-
Re: privileges to connect role
Hi,
Enter the following command:
select * from role_sys_privs where
role='CONNECT';
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
-
BLAZE: SYS> R
1 SELECT ROLE, PRIVILEGE FROM ROLE_SYS_PRIVS
2* WHERE ROLE IN ('CONNECT', 'RESOURCE')
ROLE PRIVILEGE
------------------------------ ----------------------------------------
CONNECT ALTER SESSION
CONNECT CREATE CLUSTER
CONNECT CREATE DATABASE LINK
CONNECT CREATE SEQUENCE
CONNECT CREATE SESSION
CONNECT CREATE SYNONYM
CONNECT CREATE TABLE
CONNECT CREATE VIEW
RESOURCE CREATE CLUSTER
RESOURCE CREATE INDEXTYPE
RESOURCE CREATE OPERATOR
ROLE PRIVILEGE
------------------------------ ----------------------------------------
RESOURCE CREATE PROCEDURE
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TABLE
RESOURCE CREATE TRIGGER
RESOURCE CREATE TYPE
16 rows selected.
BLAZE: SYS>
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|