Question : When my postgres function is tries to create a new sequence, it returns a permission denied error. It […]
Tag: authorization
Permission for business logic layer & application
Question : I’m very new into db development and currently working on my first production app. I learned that I […]
Create Sequence Permission for Postgres
Question : When my postgres function is tries to create a new sequence, it returns a permission denied error. It […]
Problem when extracting the structure of DB2 (Back up Structure)
Question : I want to extract the structure of a 9.7 DB2 database to use to clone it but some […]
MySQL LDAP authentication
Question : Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How […]
MySQL Views Authorization
Question : Questions: Is there a way, using SQL, to identify how many views are in the database per user? […]
Designing a database structure for a permissions system
Question : Scenario I would now like to implement a permission system so that a user is able to restrict […]
Transferring concepts – users/groups/permissions of db objects from mysql to postgresql
Question : This seemed like a better fit here than stackoverflow, so here goes: I’ve been using mysql for a […]
How to hide metadata from Postgres users?
Question : I need to provide views-only access to some subset of a database, for use by report-writing tools. It’s […]
PostgreSQL: permission denied for relation
Question : I’m a bit confused about setting permissions in PostgreSQL. I have these roles: List of roles Role name […]