Hi
I'm having an issue with MS-SQL Server View's and security, in that, I have no clue what I'm doing.
I have created 3 views in my db, that each look to separate tables.
What i want is to be able to create 2 users, one that can only read/view the view data, but not see any of the underlying tables, and another that also can't view the tables, but is able to write/read/view to the view ( if that is possible).
I will have some sensitive data in the other tables that I don't want users with the view user names to see.
The views are nothing complicated, just the complete tables but with easier to understand titles.
If I test my views with my SA user, the view works perfectly, but I need to create the locked down users.
I've read though a number of MSSQL ebooks and have come up blank, and haven't managed to find what I want via Google, because I'm not sure what I'm looking for, other than I know it can be done.
Please could someone enlighten me, as I'm sure its something quite easy, and i've just not found it.
Thanks
Jon
I'm having an issue with MS-SQL Server View's and security, in that, I have no clue what I'm doing.
I have created 3 views in my db, that each look to separate tables.
What i want is to be able to create 2 users, one that can only read/view the view data, but not see any of the underlying tables, and another that also can't view the tables, but is able to write/read/view to the view ( if that is possible).
I will have some sensitive data in the other tables that I don't want users with the view user names to see.
The views are nothing complicated, just the complete tables but with easier to understand titles.
If I test my views with my SA user, the view works perfectly, but I need to create the locked down users.
I've read though a number of MSSQL ebooks and have come up blank, and haven't managed to find what I want via Google, because I'm not sure what I'm looking for, other than I know it can be done.
Please could someone enlighten me, as I'm sure its something quite easy, and i've just not found it.
Thanks
Jon