Jr. DBA in my company only have access to the database which they need to use. Often they try to access database and if they do not have permission they face error. Jr. DBAs always check which database they have access using following system stored procedure. It is very reliable and provides accurate information. Sytanx:… Continue Reading...
Source: SQL SERVER – Stored Procedure to Know Database Access Permission to Current User | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment