I have an user called X with create session privilege and I created a table in that user X by connecting as System user.

Now I connected to the user X, I tried to drop the table which is created. I am able to drop it.

The question is I have only the create session privilege and I don't have create table privilege. When I dont have the privilege of creating a table how am I able to drop the table...? What all the roles are given to create session system privilege by default.....?


thanks,
Srikanth