Results 1 to 2 of 2

Thread: Connect role

  1. #1
    Join Date
    Aug 2010

    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
    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
    The article describing changes in CONNECT role is placed here:

    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