Programming Blog
(Move to ...)
Programming Blogs
Health Blogs
▼
(Move to ...)
Home
▼
Showing posts with label
azure sql server
.
Show all posts
Showing posts with label
azure sql server
.
Show all posts
Friday, 14 May 2021
How to check roles for sql users
›
The following query returns the members of the database roles. SELECT DP1.name AS DatabaseRoleName, isnull (DP2.name, 'No ...
Thursday, 25 February 2021
How to give SQL User access to execute Stored procedures and read/write access to database
›
Assumptions: stored procedures and tables are created under schema dbo. in case different schema, change the below code accordingly. --Cre...
›
Home
View web version