Database Administration (MOSC)

MOSC Banner

Oracle Security

edited Mar 24, 2010 7:39AM in Database Administration (MOSC) 6 commentsAnswered ✓
I am trying to assign security to a developer (account = V6PDM) in one of our test database's so they can run the following command: ALTER table v6owner.BP_LaborRoutingLink ADD ActiveFlag BIT DEFAULT 0;

I have assigned the object privileges SELECT, DELETE, INSERT and UDPATE to the table and the alter command fails

I have assigned  the ALTER ANY TABLE role and the alter command fails

I have assigned the DBA role and the alter command fails.

What am I missing?

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