What privilege is needed for a user to delete rows from tables in another schema?
- 1 Answers
- 1189 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rashi Seth
A user needs the DELETE ANY TABLE system privilege or the DELETE privilege on the specific table in another schema to delete rows. To grant the DELETE privilege, you can use the GRANT command as follows:nn`GRANT DELETE ON schema_name.table_name TO user_name;`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
