roles Image

roles

question
JohnM avatar image
JohnM commented Default

Can we create a 'user defined role' which we can read all(select permission on tables) databases?

roles

0 Likes

0Answers

1 Comment

question
Budorat avatar image
Budorat asked Default

SQL Server 2016 User accounts permissions across multiple schemas

sql server security sql server 2014 schema roles

0 Likes

0Answers

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

database role

roles

0 Likes

2Answers

2 Comments

question
saurabhsrivastava avatar image
saurabhsrivastava asked Default

Permissions required on sql server

security roles sqlserver 2008r2 serverroles

0 Likes

0Answers

0 Comments

question
lakmal82 avatar image
lakmal82 answered Default

Deny on role arnt worling

sql database roles denied

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
JohnSterrett avatar image
JohnSterrett answered Default

Cant remove user from database role

delete roles user-group

0 Likes

0Answers

1 Comment

question
EuniceRH avatar image
EuniceRH commented Default

How can a user be active:show under Activity Monitor, but not be added under Security/Users or DatabaseA/Security/Users?

security roles sql-server-2008-r2-express

This question has an accepted answer. Accepted

1 Like

2Answers

2 Comments

question
CirqueDeSQLeil avatar image
CirqueDeSQLeil commented Default

How to get the details of all SQL logins ,like, Role for that SQL login and permissions against all databases

database permissions roles

This question has an accepted answer. Accepted

0 Likes

3Answers

0 Comments

question
artistlover avatar image
artistlover answered Default

security user roles

roles

This question has an accepted answer. Accepted

0 Likes

1Answer

5 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

How to access any sys.database_principals view without sysadmin server role?

roles central-management-server

1 Like

1Answer

0 Comments

question
Venkataraman avatar image
Venkataraman answered Default

Security Model for SSAS Developer and DBA

ssas roles security-model

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Is it possible to "copy" a database role and all it's permissions to a new role?

roles

1 Like

2Answers

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Server Roles DBA's and Developers

sql security roles

1 Like

2Answers

1 Comment

question
Pavel Pawlowski avatar image
Pavel Pawlowski converted answer to comment Default

Deny selection on a table is not effective inside the stored procedure

permissions roles

This question has an accepted answer. Accepted

5 Likes

3Answers

2 Comments

question
KenJ avatar image
KenJ converted answer to comment Default

I need a SQL Statement that elevates permissions and then lowers on a time limit

roles

2 Likes

2Answers

0 Comments

27 Posts
25 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.