Return
-
Title
How to verify Oracle Permissions for TPAM? -
Description
Verify Oracle Permissions for TPAM -
Resolution
Verify if an Oracle account has SYSDBA permissions
SELECT * FROM V$PWFILE_USERS
Verify if an Oracle account has ALTER USER and CREATE SESSION permissions
SELECT * FROM dbs_sys_privs where GRANTEE = 'ACCOUNTNAME'