View security 
Author Message
 View security
How do you grant (select, insert, update and delete) permission to a view
and no permission on the underlying table so user can only work with the
view and not from the table the view is created ?


Wed, 24 Apr 2002 03:00:00 GMT
 View security

Hi Kool,
If a user 'JOE' has access to the server and access to a database, then
GRANT only SELECT on the view in the database.  The user 'JOE' cannot select
from the base table(s) unless this has been explicitly granted.

--



Wed, 24 Apr 2002 03:00:00 GMT
 View security
One clarification:
This can be done only if both view and underlying table have same
owner (say, dbo). If it's not the case, you must grant
permissions for table, too (this case called "broken ownership
chain").

Alex Dolganov
SQL Server 7.0 and IIS 4.0 MCP
Moscow, Russia

Quote:

> Hi Kool,
> If a user 'JOE' has access to the server and access to a database, then
> GRANT only SELECT on the view in the database.  The user 'JOE' cannot select
> from the base table(s) unless this has been explicitly granted.

> --




Tue, 30 Apr 2002 03:00:00 GMT
 View security
One clarification:
This can be done only if both view and underlying table have same
owner (say, dbo). If it's not the case, you must grant
permissions for table, too (this case called "broken ownership
chain").

Alex Dolganov
SQL Server 7.0 and IIS 4.0 MCP
Moscow, Russia

Quote:

> Hi Kool,
> If a user 'JOE' has access to the server and access to a database, then
> GRANT only SELECT on the view in the database.  The user 'JOE' cannot select
> from the base table(s) unless this has been explicitly granted.

> --




Tue, 30 Apr 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Displaying data from a view (Security???)

2. Field and View security question?

3. View Security

4. View Security

5. Table/View Security

6. Views...security

7. VFP6, FTP, and remote view security questions...

8. Interbase Trigger/View/Security Problem

9. "view security" and ADO does not work?

10. SqlServer Views for Security

11. Security with views (simple question)

12. VIEWS as Security for SQL/Access?


 
Powered by phpBB® Forum Software