Hi Experts,
I have created a user and given some privileges.
After connecting to the user , I can see all session privileges whatever I have given.
SQL> select * from session_privs;
PRIVILEGE
----------------------------------------
SET CONTAINER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE TYPE
CREATE TRIGGER
CREATE PROCEDURE
CREATE SEQUENCE
CREATE VIEW
CREATE CLUSTER
CREATE TABLE
CREATE SESSION
11 rows selected.
SQL> show user;
USER is "TEST_USER"
My Question is
Without connecting as "TEST_USER", is it possible to get all associated privileges of the user ?
DB : 12.2