var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: allow access to 1 view only
What is the best and simplest way to give access to only 1 view to a remote system?
I have a remote reports system that need access to my SQL. They only need access to 1 view at my sql to retrive their data.
They login with their account using TCP/IP connection and a local SQL account
What role, access should i give the account, etc?
The SQL is SQL2008 standard 64-bits
thanks in advance
First, lock down the "Public" role so that it has no database access.
Then, create a role that has only read access to the specific view you mention. Assign your users to this role.
thanks, i manage to do this and it seems to work just fine exepct that when i connect to db i can see the sys tables (and can export them) and i guess i have not been able to lockdown public role correctly... How should i lockdown public role?
edit: it seems like i need to get access to the tables that the view uses?! How to solve this?
Last edited by mrpcguy; 10-26-10 at
You can either open up the security permissions on each of those objects and revoke Public's privileges, or you can open up the Public role's privileges and rescind privileges on the system objects.
Have you considered not giving them access at all and opting for other delivery methods? Do they NEED access to the view in real time?
some times it is necesary that they have real time access , teddy