CODEWITHSUNDEEP
oracle-database
Thomas Carlton
Thomas Carlton

Reputation: 5968

Can sys or system users access ANY table in database?

Can sys or system users access ANY table in oracle database, including the ones they don't have explicit grant to ?

Let's say for example I have a user : MyUser who have a table MyTable. MyUser didn't grant an explicit privilege to sys or system to access this table. Can Sys or System access it though ?

Thanks

Upvotes: 0

Views: 195

Answers (2)

gvenzl
gvenzl

Reputation: 1891

The SYS and SYSTEM users are administrative users and have the DBA role granted by default. Part of the DBA role is the ANY TABLE privilege which allows them to access any table within the Database. This can of course be a problem with regards to security. To address that Oracle introduced a product within the Database called Database Vault.

Upvotes: 1

neshkeev
neshkeev

Reputation: 6476

System ans Sys are administrators, they have access to any table, but if there is no public synonym on a table then these accounts have to use fully qualified name, like: 

select *
  from HR.employees

or

select * 
  from SH.sales

Upvotes: 1

Related Questions