DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: privileges to connect role

  1. #1
    Join Date
    May 2002
    Posts
    163

    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    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
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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>

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width