All Questions
9 questions
0
votes
1
answer
421
views
Does SSRS report user needs database level permission?
I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
- 1,063
4
votes
2
answers
6k
views
Can SET IDENTITY_INSERT be allowed with less privileges than db_ddladmin?
I've inherited a system where the application is running under sysadmin account.
I limited this account to db_datareader + db_datawriter + EXECUTE on all database and set extended events session to ...
- 11.2k
1
vote
0
answers
2k
views
Grant permissions over linked server
I need to grant select permissions to a sensitive table over the linked server. This table should only grant access to members of an AD group. I currently have other linked servers set up with remote ...
- 373
4
votes
2
answers
19k
views
What are SHOWPLAN permission security risks? (MS SQL Server)
I'm having some friction when it comes to showplan permission security.
Say there are 5 databases on a server. And each one has a test/ production split (so 10 total).
There is one sysadmin.
There ...
- 1,709
3
votes
1
answer
2k
views
Granting SELECT permission on a object
I am not sure if this is an odd question, so please let me know if what I describe below is possible.
We have a server, which is configured by someone else and none of us are "added in it".
As of ...
- 1,600
5
votes
2
answers
3k
views
Recover SA Password - PSTools - Not working
I'm on a new company, and the first thing I saw is that they don't even know how many instances they have. they don't have passwords and the old DBA had no Idea what he was doing.
long story short, I ...
- 7,484
2
votes
1
answer
3k
views
Grant access to all objects (with a few exceptions) to a role
In SQL Server 2014, I want to create a role that will have access (select, delete, update, insert, execute) to all the tables, views, stored procedures, except a certain list of tables that contain ...
- 63
4
votes
1
answer
23k
views
Permission in schema for user
I created a default database and created some schemas within this database. Created users for each schema, now I want to give full permission for each user in your schema only, how should I do?
- 141
2
votes
2
answers
17k
views
Issues with module signing and SSIS catalog internal procedures
I'm trying to set up a stored procedure to execute an SSIS package. I want to allow a user to execute only this stored procedure, so I need it to run as a different user.
I found this article which ...
- 1,051