I have a user account in a database that can create tables and Stored Procedures.
I would like to confirm if this user account can Create Schemas - WITHOUT trying to do it first. (I am part of finance not IT) If I CAN create Schema's then I'll ask IT for permission to go ahead and do so. If I CAN'T then I'll just continue to wait for IT to do it on the Service Desk request I put in some time ago sigh
Is there a command I can run in SSMS that will tell me this without actually creating a new Schema?
I have also taken a couple of screenshots of this user's permissions - maybe they will have the answer?
EDIT: Having run the SQL suggested by SQLServing below, I get this result:
UserName is_disabled principal_type_desc class_desc object_name permission_name permission_state_desc DWReports 0 SQL_USER DATABASE NULL CONNECT GRANT DWReports 0 SQL_USER OBJECT_OR_COLUMN GetSystemSQLAgentJobList EXECUTE GRANT