Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

Manjuke Fernando

Rate me:

5.00/5 (1 vote)

26 Oct 2015CPOL2 min read

7.5K

Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed immediately. And only few people should be able to access the server with full privileges.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Manjuke Fernando

Technical Lead Air Liquide Industrial Services (Singapore)

Singapore

My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies.

My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers.

My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science.

Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports

Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

Views

License

Comments and Discussions