Role Assignment not working for ATP Custom User
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.