Monday, May 3, 2021

Differences in System Privileges for typical DBA users granted in RDS and on-premise setup

System Privileges only granted in AWS RDS 19c:

  • ALTER DATABASE LINK
  • ALTER PUBLIC DATABASE LINK
  • EXEMPT ACCESS POLICY
  • EXEMPT IDENTITY POLICY

 System Privileges only granted in 19c PDB in on-premise setup:

  • ALTER DATABASE
  • ALTER SYSTEM
  • CREATE ANY DIRECTORY
  • CREATE EXTERNAL JOB
  • GRANT ANY PRIVILEGE
  • GRANT ANY ROLE
  • READ ANY FILE GROUP

No comments:

Post a Comment