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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 20225

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

5
votes
list of server level roles and see what matches your needs. Just remember that someone with securityadmin for example could create a login with sufficient permissions to affect the databases. …
answered Feb 1 '16 by Kenneth Fisher
2
votes
? Permissions for the most part are handled on a database by database level. You can look at it through the GUI (security dropdown under the DB in the object explorer among other places) or there are lots of … queries out there that can help you. I've got two sp_dbpermissions sp_srvpermissions that will help you list out the permissions for a given user/db/etc. Once you have determined what …
answered Aug 6 '15 by Kenneth Fisher
4
votes
I've got a couple of stored procedures you can use to display all of the permissions for a given database. Either for a single user/principal or for all of them. sp_dbpermissions and … search out permissions directly applied to a given object (similar to your query above) or members of a given role (and the permissions for that role) etc. Note: Minion also has an enterprise edition …
answered Jan 4 '16 by Kenneth Fisher
5
votes
want to create a script that will drop all of your existing permissions from the copy of the prod database and another that will generate all of the permissions that used to be there. My personal … database. This time you will want to copy the last column from each of the three result sets. This will give you the CREATE USER, sp_AddRoleMember and GRANT/DENY commands to add the permissions for …
answered Nov 24 '14 by Kenneth Fisher
1
vote
permissions will remain intact. That being said you may have some issues if you don't prepare properly. Logins and Users are different objects in SQL Server. The first is a Server level principal and … permissions in the role. There are a number of ways to make sure that the SID is the one you want including using the sp_rev_helplogin and my sp_srvpermissions. I discussed the problem in more detail here. …
answered Jan 26 '15 by Kenneth Fisher
1
vote
0answers
One of my DBAs is trying to look at the database properties of a database by right clicking and selecting properties and is getting the following error: Cannot show requested dialog. (SqlMgmt) …
asked May 3 '18 by Kenneth Fisher
3
votes
The problem is with the difference between logins and users. When you are granting the permissions you are working with a user. Only a login can have server level permissions such as sysadmin. I … . Because you made the database trustworthy it will allow users in it to access server level permissions. All of this means that your stored procedure will be able to act as a sysadmin. Next grant …
answered Mar 31 '13 by Kenneth Fisher
0
votes
situations where you need to go past the following: Read Write Execute ddl_Admin view definition In this case in order to grant the permissions you want you can do the following: EXEC …
answered Apr 21 '17 by Kenneth Fisher
2
votes
1answer
could be wrong. I checked and the associated permissions (SQLAgentReaderRole, SQLAgentUserRole, PUBLIC in msdb and master) and they appear to be the same. …
asked Aug 7 '15 by Kenneth Fisher
2
votes
use the CREATE permissions. There is a small trick to using them however. You will also need to grant ALTER on the schema where they can create/alter the objects. So to grant the ability to create … , CREATE FUNCTION etc. The reason you need both is this: CREATE PROCEDURE gives you the ability to create the procedure, ALTER schema gives you a place to put the procedure as you create it. I should also point out that the CREATE permissions also grant the ability to alter, and drop. …
answered Feb 11 '16 by Kenneth Fisher
1
vote
Here are some scripts I've been working on for something similar. The queries themselves should be fine, the "scripting" parts are still a bit of a work in progress however. @Paul's answer is probab …
answered Jul 29 '13 by Kenneth Fisher
9
votes
1answer
I was asked to grant SELECT, INSERT and UPDATE to a given user for all tables in a database. I ended up adding the user to db_datareader and granting them INSERT and UPDATE at the database level. …
asked Aug 28 '13 by Kenneth Fisher
2
votes
While I can't be certain because you blanked out the Grantor I think you will find that the rows have a different entry in that column. It is possible to have multiple entries of a permission in that …
answered Jan 20 '14 by Kenneth Fisher
1
vote
I've got a stored procedure you can use for the purpose. sp_dbpermissions When you run it it pulls all of the permissions for the database into three result sets. The first is a list of … principals, the second is role membership and the last is direct permissions (GRANT EXEC ON SP for example). Each result set includes a script to remove said permission and another to create it. Best of all …
answered Mar 29 '16 by Kenneth Fisher
6
votes
particularly useful when I've granted permissions but the user is still telling me they can't perform a given task. Collecting information There are a number of system views/functions that give you … information about the connecting principals permissions (even some AD information). As an example if I impersonate a database principal (user) and query sys.user_token I can get a list of all AD groups they …
answered Jul 15 '16 by Kenneth Fisher

15 30 50 per page