Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Azure SQL User/Connection String that can only see one table

Hi

In Azure SQL is it possible to set up a user or connection string that can only see one table?

Thanks
Avatar of HainKurt
HainKurt
Flag of Canada image

yes you can... create a user/login and just give select permission on one table
and use that login/password in your connection string...
Avatar of Murray Brown

ASKER

Thanks. How do you give select permission on one table?
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks very much for the help!
have a look at this forum for further info / setup user / login properly with minimal grants

Allow update access to only 2 tables in a database schema
https://dba.stackexchange.com/questions/56587/allow-update-access-to-only-2-tables-in-a-database-schema
Thanks. I will do