Oracle Database Discussions

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!

Revoke delete from user error.

890271Jan 27 2012 — edited Feb 4 2012

Hi all,

im Using Oracle 10g. i need to revoke delete privilage(To delete data's from a table ) for a user.

when i run this query: "revoke delete from user_name" i got error.

ora-01919: role 'delete' does not exists.

i dont want to grant/revoke a role. i need to REVOKE DELETE PRIVILAGE from a user.

Help me.....

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2012

Added on Jan 27 2012

#general-database-discussions

11 comments

1,293 views