Oracle user's session privileges

As an oracle user logged into database,sometimes we need to know about what are our limitations.


What we can do as per our privileges. Most of the time we work without knowing our capabilties.

The SESSION_PRIVS will show us the assigend privileges to that user.

 
SQL > SELECT * FROM SESSION_PRIVS;
 
PRIVILEGE
1 CREATE SESSION
2 ALTER SESSION

For that user those are the assigend privileges.