HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Database User Securables Question

Submitted by: @import:stackexchange-dba··
0
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!

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 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.