database-permissions
Prevent SQL Server Table operations (INSERT and DELETE) on some tables
While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked[详细]
2022-12-28 05:56 分类:问答SQl server 2008 permission and encryption
i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But开发者_如何转[详细]
2022-12-22 12:29 分类:问答Restrict stored procedure to only perform SELECT operations
Is is possible to restrict a stored proc to only SELECT from a database. I want a stored proc which only selects data to execute correctly and a stored proc with UPDATE, CREATE, DELETE operations to[详细]
2022-12-20 00:34 分类:问答SQL Server - Limit the databases view based on login
I have a situation where I want to limit the database view per user login. For example: I have 3 databases in my SQL Server instance called MyDB, UserDB, RestrictedDB.[详细]
2022-12-19 20:10 分类:问答How to stop mySQL users calling "show" functions
How can we p开发者_StackOverflow中文版revent the the query \"show databases;\" or \"show tables;\" in mysql for any non root user.Is this possible.If so please provide an example or appropriate link..[详细]
2022-12-13 02:44 分类:问答Copy permissions from another table
Is it possible to copy the user permissions from one table in a PostgreSQL database to another table? Is it just a matter of updating the pg_class.relacl column value for the target table to the value[详细]
2022-12-12 18:20 分类:问答