Contents
What restrictions are necessary to ensure that a view is updatable?
If you want a join view to be updatable, then all of the following conditions must be true:
- The DML statement must affect only one table underlying the join.
- For an INSERT statement, the view must not be created WITH CHECK OPTION , and all columns into which values are inserted must come from a key-preserved table.
How can a view be used to prevent access to sensitive columns?
2 Answers. The solution is to create a view joining the data table with a row from the security table containing information about access to sensitive data for the logged in user and then using conditions in the SELECT clause to nullify sensitive columns if a user does not have access to them.
How does view enhance data security?
Answer: Views add two more levels of security: A view can limit access to only selected columns of the base table. A view can provide value-based security for the information in a table. Thus a WHERE clause in the definition of a view can display only selected rows of a base table.
Do you need permission to query underlying tables?
Just the View (A). Granting Select on the underlying tables will give them more access than they may need. The link below has some helpful info on ownership of the view\able and the affects it may have on your access. Grant SELECT permission on a view, but not on underlying objects.
How to give read only access to a user?
I have 2 users are present in oracle ex User1 and User2, Under user1 some tables are present ex t1,t2,t3 etc.. . what are the minimum permissions to view the tables of user1 by using user2 ( Just want to view the table description not the Data) . SQL> create user u1 identified by u1; User created.
Can a user view a table in SSMS?
The user currently has permissions set to access & modify the table ( SELECT, UPDATE, DELETE, etc) through the dbo_datareader and dbo_datawriter roles. However, they cannot see any of the tables in the SSMS object explorer.
Can you view tables in non default schema?
Using them will cause issues like the one you are facing. If you want to give principal Alice the SELECT, INSERT, UPDATE and DELETE permissions to all table-valued objects in schema Sales then use the following.