Murray Brown
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
In Azure SQL is it possible to set up a user or connection string that can only see one table?
Thanks
ASKER
Thanks. How do you give select permission on one table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
Thanks. I will do
and use that login/password in your connection string...