Database Security Products (MOSC)

MOSC Banner

Is this list of privileges too generous to a developer?

edited Oct 8, 2009 7:02PM in Database Security Products (MOSC) 9 commentsAnswered
 Hi,

    CONNECT  <--------------------------------Role
      ALTER SESSION
      CREATE CLUSTER
      CREATE DATABASE LINK
      CREATE SEQUENCE
      CREATE SESSION
      CREATE SYNONYM
      CREATE TABLE
      CREATE VIEW
    CREATE ANY INDEX
    CREATE SNAPSHOT
    CREATE SYNONYM
    RESOURCE  <------------------------------Role
      CREATE CLUSTER
      CREATE INDEXTYPE
      CREATE OPERATOR
      CREATE PROCEDURE
      CREATE SEQUENCE
      CREATE TABLE
      CREATE TRIGGER
      CREATE TYPE
    SELECT ANY DICTIONARY
    SELECT ANY TABLE
    UNLIMITED TABLESPACE

Above is a list of system privileges given to a developer in a production database.   Is this kind of privilege list normally given to a developer?  For some reasons the role CONNECT contains many system privileges.

Thanks,

Simon

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center