Top "Database-permissions" questions

Why did PostgreSQL merge users and groups into roles?

From the PostgreSQL docs: The concept of roles subsumes the concepts of "users" and "groups". In PostgreSQL versions before 8.1, users …

postgresql roles database-permissions
TSQL - Executing CLR Permission

I got a sql procedure from a CLR (.net Assembly) that when executed returns an error Msg 6522, Level 16, State 1, Procedure …

sql-server tsql sqlclr database-permissions
SQL Server 2008 Grant Select Permission

I am having trouble adding a user to a test database I set up on my local machine. I have …

sql sql-server database-permissions
Grant Execute Function permission to another user

I have a database function fn_relation_isModerator, only user api has access to this function. Now I want another …

mysql stored-procedures grant database-permissions
PHP Access Control System

I am part of a team creating a web application using PHP and MySQL. The application will have multiple users …

php database-design permissions access-control database-permissions
Copying permissions from one mysql database to another

I would like to replicate the permissions from one database to another. Could that be done by simply copying the …

mysql database-permissions
Efficiently determine owner of a record in a hierarchy with MongoDB

I am trying to achieve the following: Select all the records that I own, where ownership is objects I have …

mongodb database-design database-permissions database