User permission in Oracle tables

Asked

Viewed 1,397 times

1

There is a way to know which tables a particular Oracle database user is allowed to select?

oracle oracle11g

  • Accessing as DBA/SYS or as the user himself?

  • 1

    What would be the command ? As the user himself does not interest me much, because the intention is that if there is a way, use as audit. Some user may have received permission in some table long ago and today may no longer be required or allowed.

1 answer

1


Accessing as DBA/SYS:

SELECT *
  FROM dba_tab_privs dtp
 WHERE dtp.privilege = 'SELECT'
   AND dtp.GRANTEE   = 'USER' -- Usuário para quem o acesso foi concedido
  • 1

    Great David. That’s what I was looking for. Thank you!

Browser other questions tagged oracle oracle11g

You are not signed in. Login or sign up in order to post.