Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with permissions
Search options questions only
not deleted
user 47215
Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
0
votes
1
answer
496
views
List users permissions to tables and schemas on MSSQL 2016
List all permissions for a given role? has a nice query for listing users and their roles on a DB.
How could we list all tables and users with their permissions on these tables? …
- 1,573
0
votes
4
answers
749
views
What role is able to grant role permissions on MSSQL 2016?
We'll split roles permissions in 3 groups:
1) readonly (SELECT) with specific write (INSERT,UPDATE,DELETE) on some tables
2) DDL (ALTER) without RW
3) "restricted admin" custom role, able to add other … AD groups and users to existing roles
But I can't find what role is able to grant and revoke permissions without being a db_owner. …
- 1,573
12
votes
3
answers
63k
views
SQL Server: grant select access to a user in a view and not in its tables
I have a SQL Server 2012 instance with a few databases. In one of them I created a view, that selects tables in more than a database.
I want a user to be able to select that view, but it must not sel …
- 1,573
16
votes
2
answers
64k
views
SQL Server : which role grants permission to execute all stored procedures?
Which database role membership grants permission to execute all existing stored procedures in SQL Server 2012?
I tried adding a user to each of them and am still unable to execute a stored procedure. …
- 1,573
4
votes
1
answer
9k
views
Verify if user has read access to a table
I'm developing an ETL, which must read data from a table.
There are times that my user's access to that table is revoked. So, to avoid the ETL failing, before reading the table I must verify if I have …
- 1,573
0
votes
2
answers
2k
views
SSMS connects, Linked server fails
The OLE DB provider "SQLNCLI11" for linked server "SERVER" indicates that either the object has no columns or the current user does not have permissions on that object. …
- 1,573
1
vote
1
answer
2k
views
Deny users permission to create tables in master
I have noticed that I can create tables, schemas, stored procedures etc. the master database.
I don't know what is granting this permission. It's annoying, because when we open a *.sql file in SSMS, …
- 1,573
4
votes
1
answer
14k
views
Create Linked Server using Active Directory account
I was able to grant access in MSSQL to an Active Directory group and add a service account to that group. It's working fine, I'm able to use trusted connection to login on that MSSQL using both my per …
- 1,573
2
votes
1
answer
2k
views
Unable to set user/group as principal on a proxy
I'm organizing permissions on our SQL Server instance. … I want to stop using a SQL Server account, and instead grant permissions to Active Directory groups, and then add user and service accounts to these groups. …
- 1,573
4
votes
2
answers
11k
views
Grant Admin to an Active Directory account in SQL Server
I have a SQL Server 2012 instance, and an Active Directory group, which I can add Active Directory users to. I have my personal AD account (MyAccount) and a service account (ServiceAccount) in that gr …
- 1,573