Top "Database-permissions" questions

no pg_hba.conf entry for host

I get following error when I try to connect using DBI DBI connect('database=chaosLRdb;host=192.168.0.1;port=5433','postgres',...) failed: …

perl postgresql database-permissions
What GRANT USAGE ON SCHEMA exactly do?

I'm trying to create for the first time a Postgres database, so this is probably a stupid question. I assigned …

database postgresql schema grant database-permissions
Grant a user permission to only view a MySQL view and nothing else

This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too. Let's say I have a table with records …

mysql view permissions database-permissions grant
Permissions for truncating a table

What permission do I need to GRANT a user, in MSSQL, in order to be able to truncate a table? …

sql-server database-permissions
The error "Login failed for user 'NT AUTHORITY\IUSR'" in ASP.NET and SQL Server 2008

My ASP.NET v3.5 web application is throwing the following exception when it attempts to open a connection to a …

asp.net sql-server iis-7 database-permissions
How to create a user with readonly privileges for all databases in Postgresql?

I want to create a user with only select privilege for all tables in all databases. I thought that I …

security postgresql permissions database-permissions
Why does PHP PDO get "SQLSTATE[42000] [1044] Access denied for user" when mysql command line works?

My head is bloody from how hard I've been banging it against this wall for the past several hours. :( As …

php mysql database pdo database-permissions
How to give access to SQL Server database mail procedures for a Login in a different database?

I'd like to know how to set up permissions within SQL Server to allow my application Login/Role to be …

sql-server sql-server-2005 database-permissions database-mail