Results 1 to 2 of 2

Thread: Connect role

  1. #1
    Join Date
    Aug 2010
    Posts
    5

    Unanswered: Connect role

    Is it right that CONNECT role has create and alter privileges? I found it reviewing SYS.DBA_SYS_PRIVS.

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    If DBA_SYS_PRIVS says so, then it definitely has.

    Generally, it depends on Oracle version as its privileges changed in 10gR2. You can consult it in Security Guide, available with other Oracle documentation books e.g. online on http://tahiti.oracle.com/
    The article describing changes in CONNECT role is placed here: http://download.oracle.com/docs/cd/B...a.htm#CHDJDIIB

    Lastly, you should follow the recommendation, available e.g. in SQL Reference book:
    CONNECT, RESOURCE, and DBA roles:
    These roles are provided for compatibility with previous versions of Oracle Database. You can determine the privileges encompassed by these roles by querying the DBA_SYS_PRIVS data dictionary view.
    Oracle recommends that you design your own roles for database security rather than relying on these roles. These roles may not be created automatically by future versions of Oracle Database.

Posting Permissions

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