Database Administration (MOSC)

MOSC Banner

DBA but should not select the data in business schema tables.

edited Apr 5, 2011 2:23AM in Database Administration (MOSC) 5 commentsAnswered
 Hi All,

I want to know a role or method to provide all DBA activities (maintence and administration)  for user but he should not view the data in the actual business schema tables.

I gone through the documentation,  for RMAN backup he should connect to the target database as SYSDBA privilege.  If I give sysdba privilege then he can see the data the business tables.

If I grant SYSOPER privilege then he can not create the database objects(DDL).

All that I want to know how to create a user who has all DBA privileges and select data in dictionary tables, v$ tables but not business tables.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center