Tagged Questions
2
votes
1answer
74 views
Even when user has 'bulkadmin' role, query says user does not have role - SQL Server 2012
I am facing a weird issue with SQL Server 2012.
I have a user (say RS\sqluser) which has bulkadmin role.
Now when i run this query
Select IS_SRVROLEMEMBER('bulkadmin', 'RS\sqluser')
output is 0. ...
4
votes
2answers
119 views
Track grant permission on tables
I'd like to see if there are any changes on the permissions granted for a specific table.
For example, I don't want to have the login 'John' have the SELECT permission on the table Invoices.
If ...
2
votes
1answer
195 views
How to grant permission for am administrator account in SQL Server 2012? [closed]
I installed SQL Server 2012 on my laptop. I am trying to run a script to create a simple database.
SQL Server version: 11.0.3128
SSMS starting parameters:
server type: database engine
server name: ...
