Role Assignment not working for ATP Custom User

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.