The authorization tag has no wiki summary.
4
votes
1answer
3k views
PostgreSQL: permission denied for relation
I'm a bit confused about setting permissions in PostgreSQL.
I have these roles:
List of roles
Role name | Attributes | Member of
...
2
votes
2answers
482 views
Why database diagrams are not working when domain account is attached to database owner?
I was trying to use Database diagrams is SQL Server and got following error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
1
vote
1answer
306 views
How to implement an effective ACL/auth in a relational db?
We are looking at implementing an ACL that fulfills the following requirements:
Most users have access to an item (access to the item by default), but a few is denied access.
Most users do not have ...
2
votes
2answers
286 views
MySQL Views Authorization
Questions:
Is there a way, using SQL, to identify how many views are in the database per user?
How can you authorize/deny users access to delete views created by another user?
2
votes
2answers
392 views
How to hide metadata from Postgres users?
I need to provide views-only access to some subset of a database, for use by report-writing tools. It's easy enough to use permissions to prevent access to the data in the underlying tables, but I ...
2
votes
1answer
599 views
Is it possible to specify Active Directory username and password in connection string?
My organization uses Active Directory to control access to our databases. Building web applications and as part of our CI process I would like to specify the credentials in the connection string.
Is ...
2
votes
2answers
370 views
Transferring concepts - users/groups/permissions of db objects from mysql to postgresql
This seemed like a better fit here than stackoverflow, so here goes:
I've been using mysql for a while since on most of the cheap webhosts it is the provided database. However, now I've started ...
8
votes
3answers
1k views
MySQL LDAP authentication
Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How it's organized?
Thanks.
