I created SQL DB. and I want to allow only "DB owner" to access stored procedures. I want to prevent all other users including 'sa' user from doing that . how to do that ?
Allow only dbonwer from accessing stored procedures
46 Views Asked by Raed Alsaleh At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in SQL-SERVER-2012
- Able to initially retrieve string from varbinary but not able to retrieve it again after setting it from ascii file?
- ASP.NET Core web application running slow & occasionally timing out while running large queries to database after updating to .NET 8
- Connecting to API via Microsoft SQL Server 2012
- SQL Substring from a column of strings
- Sum time of consecutive rows with condition of filed
- Trying to delete records from a table that has 20 million records
- CROSS JOIN and STDistance to find closest point
- Getting the Penultimate Record from a Table Sorted by Descending ID
- Make 1 row result from two result using SQL Server
- How can I reliably store an ID so that I can use it in another INSERT statement?
- How can I add a whole column of data as a row?
- SQL loop invalid because no scalar variable?
- Not understanding why this .bat file is only pulling some XML info and not all
- SQL Hierarchy Fill Down
- Row Number to give same value when same partition
Related Questions in SA
- I can not login with sa user with entity framework in .net core web api project 6.0. I am able to login on with sa user on sql server management
- storage bucket permissions GCP
- Strong password for SQL Server doesn't follow the documentation
- 'sa' user is "pinging" my Azure SQL Database
- set mixed mode authentication in SQLCMD
- why I search Milvus return `The vector dimension must be equal to the collection dimension`?
- NER german natural objects
- How can I copy CTRL-C content from a single cell in DBISQL?
- SA default password SQL Server on Linux
- SQL Server 2014 sa account audit trail
- Sql Server 2012 enterprise "sa" login failed. Error: 18456
- Why I cannot change sa password using osql?
- Is it possible to remove SPI from IPSec header?
- SQL Srv 2016: Login failed for user 'MicrosoftAccount\...'
- Print my sa password
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
short answer: you can't.
long answer: sa is the owner of the whole server so cannot be cut out of anything on the server. you can prevent all other users (that does not have a sysadmin role) from using the stored procedures but again you have no way to lock out sa and/or any user with sysadmin role.
you may revoke permission to SA but SA can grant these permissions back easily.
actually you may lock out SA user if you disable SQL authentication or disable the user but anyway you cannot prevent other users with sysadmin role to interact with the stored procedures: this is by design.
please post a question with the actual requirement: this question looks like a solution you are trying to implement; maybe we can help you find a suitable solution for the actual issue.
as a side note, if you don't trust the admin of the server there is something wrong...