patternMinor
Database User Securables Question
Viewed 0 times
databaseusersecurablesquestion
Problem
Learning sql server over here and I'm trying to figure out how to see the securable permissions I have added via T-SQL , in SSMS
For example, I have a database user called "LoginUser1" in Database1 and I granted "grant create table, create view to LoginUser1".
I'm trying to see this permission in SSMS. I go to the properties for the user in this database but i'm not seeing anything. What am I missing?
Thanks!
For example, I have a database user called "LoginUser1" in Database1 and I granted "grant create table, create view to LoginUser1".
I'm trying to see this permission in SSMS. I go to the properties for the user in this database but i'm not seeing anything. What am I missing?
Thanks!
Solution
Query presented by @S4V1N will do the trick. If you have to see it via GUI using SSMS you can select:
Database → Properties → Permissions → Select the user
Select Explicit, you will see this.
Select Effective, you will see this.
Database → Properties → Permissions → Select the user
LoginUser1 from Users or roles: list.Select Explicit, you will see this.
Select Effective, you will see this.
Context
StackExchange Database Administrators Q#177634, answer score: 5
Revisions (0)
No revisions yet.