Top "Database-permissions" questions

Grant privileges on several tables with specific prefix

I'm using the table prefix method for having several clients use the same database. The number of tables created per …

mysql database grant database-permissions
Sql server execute permission; failure to apply permissions

I've just migrated from SQL2000 to SQL2008 and I have started getting an execute permission issue on a stored proc …

sql-server security sql-server-2008 database-permissions
Permissions required to run 'ALTER DATABASE SET SINGLE_USER' statement on SQL Server 2008

I've came across the case when the following statement throws an error saying it can't be executed because of the …

sql sql-server sql-server-2008 database-permissions
List of tables that a user has SELECT privilege for in MySQL

Short version: How can I write an SQL procedure to list which of several tables in a MySQL database a …

mysql database-permissions
How do I check which schemata have been granted EXECUTE permission on an Oracle object?

I need to find out which schemata have already been granted execute permission on a certain object in an Oracle 10…

oracle oracle10g database-permissions grant
sql open connection in read only mode

This question comes out of curiosity. I searched google for this but didn't get a clue. Suppose a user has …

mysql database-connection database-permissions
Granting mysql access rights to all machines on subnet

I have a mysql instance (and schema) running on windows that I can access via a connection string based on …

mysql security database-permissions subnet
Listing table results in "CREATE TABLE permission denied in database" ASP.NET - MVC4

I'm using ASP.NET MVC 4 - c# to connect to a live database, and list the results, however when I …

c# asp.net-mvc asp.net-mvc-4 database-connection database-permissions