Answer Posted / ashokram s
Using view you can restrict the data and thus granting privilege on the view instead of base table can ensure security that all data cant be accessible by a particular user
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention what plvcmt and plvrb does in pl/sql?
What is group function in sql?
How many types of keys are there in sql?
What is sql dialect?
Can we use pl sql in sql server?
What is #table in sql?
What is asqueryable?
What is a constraint?
What is the use of index in hive?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What's the procedure?
How can you select unique records from a table?
what is the difference between a having clause and a where clause? : Sql dba
How many tables can you join in sql?
What is java sql connection?