Is this list of privileges too generous to a developer?
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