On SSE_ROLE DBA alternative

There is often an awkward quandary among DBA's whenever the development team asks the DBA to create SSE_ROLE per Oracle documentation. This is true especially in production.

Per Oracle Docuentation:
CREATE ROLE SSE_ROLE;
GRANT DBA TO SSE_ROLE;
GRANT SSE_ROLE TO OBAW;

I suggest the following alternative to my clients:
Grant schema with CONNECT, RESOURCE, and SSE_ROLE_ALT. Use SSE_ROLE_ALT instead of SSE_ROLE

Grant below privileges to OBAW:
CREATE TABLE
CREATE TRIGGER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE INDEXTYPE
CREATE CLUSTER
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mohan Ramanuja is a techno-functional strategy and transformation executive with over 15 years of experience in the enterprise software and professional services industries. Prior to joining Oracle, Mohan held progressive leadership roles in managing/executing projects. Outside of his role, he advises start-up companies, publishes on business strategy and transformational topics, and speaks at industry events and conferences.

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today