SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create session privillege has problem in 10g

677120Jul 29 2010 — edited Aug 11 2010

Hi ,

I would need to create a user who only has access to select/update and delete records from the tables of a schema. For that , when I grant Connect/Create session privillege, the user is able to drop the table, alter the table by default.

Is it a bug that only providing create session privillege, user is able to drop the table and alter the table etc.
I am using Oracle 10g database.

Thank u,
Raji

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2010

Added on Jul 29 2010

#issue, #session

7 comments

1,276 views