New answers tagged access-control
As I was stuck in not seeing "User-Level Security Wizard", I made my way to access it by including this item to the custom ribbon tab: After that I was able to continue and create users for the DB.
Here's what I came up with -- thanks to @CL. for the tips. I made it into a view so I can just query against that for a particular user. CREATE VIEW user_permissions_deep AS SELECT DISTINCT user_id, permission_id FROM ( SELECT urd.user_id user_id, pr.permission_id permission_id, urd.role_id role_id, urd.parent_id parent_role FROM ( WITH ...
Unfortunately that's not that easy because there is no "select any view" privilege (as e.g. Oracle offers). If you can put all views into a single schema, then this could be achieved by granting the select privilege on that schema. Something like this: First you need to create a role that can be used for this create role view_reader; The role only ...
You can use any of the two methods below to connect to SQL Servers in a remote domain and continue using Windows Authentication. 1) runas /netonly 2) Through credential manager You can achieve this as explained here
You will have to setup a linked server forwarding the user credentials between the instances. There are step by step instructions here: It boils down to running this on DB_INSTANCE1\DB1 EXEC sp_addlinkedserver @server=N' DB_INSTANCE2', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N' DB_INSTANCE2\DB2'; sp_addlinkedsrvlogin @rmtsrvname = ...
Top 50 recent answers are included