I recently have an issue of giving privileges to a Database support user that user for application team to do production support. I have grant Select any dictionary and Select Catalog role to the user, but still they still not able to view the SQL tabs(DDL scripts) on Sqldeveloper from other users and giving ORA-31603.
I tested in UAT database all are ok without any issue to view the DDL tab. After comparing what is the different between UAT and PROD sqldeveloper, found out that when I grant "Select Catalog Role" it is not the default Role of that user. After adding "Select Catalog Role" as a default role to that support user, it works perfectly now.
Not sure if this only happen to my environment. We use Sqldeveloper-Version 2.1.1.64.
I tested in UAT database all are ok without any issue to view the DDL tab. After comparing what is the different between UAT and PROD sqldeveloper, found out that when I grant "Select Catalog Role" it is not the default Role of that user. After adding "Select Catalog Role" as a default role to that support user, it works perfectly now.
Not sure if this only happen to my environment. We use Sqldeveloper-Version 2.1.1.64.
No comments:
Post a Comment