What privilege is needed for a user to delete rows from tables in another schema?
- 1 Answers
- 1188 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is Index Cluster ?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
What are the components of Logical database structure of ORACLE database?
What is difference between truncate and delete?
How do you ensure database security?
Display the number value in Words?
How to create a server parameter file?
What is a dead lock in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
How to run create database statement?
Can select statements be used on views in oracle?
How to create id with auto_increment on oracle?
Oracle General 
