You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Role Assignment not working for ATP Custom User

Received Response
41
Views
5
Comments
edited Jan 12, 2024 11:13PM in Autonomous Database 5 comments

Hi Team,

We provisioned a new ATP and using web console created new DB user and assigned unlimited quota, connect, resource and DWRole. We are able to connect from SQL developer with new schema/user but not able to create any table and its giving insufficient privileges error.

We followed the Oracle doc- https://docs.oracle.com/en-us/iaas/autonomous-database-serverless/doc/manage-users-privileges.html but its not working even if we assign Dwrole using sql command.

But when we assign CREATE TABLE access seperately - we are able to create table. Can you please help in fixing this issue.

We even created a custom role with the same privileges as DWROLE and assign the custom role to user its not working.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!