I have an application (based on the Qt library) which uses QPSQL driver.
In PostgreSQL, there are a few user roles defined (e.g: admin, operator, user). My application creates a connection to the Postgres server under a specified user. How can I check the user's role?
Add a comment
|
2 Answers
SELECT current_user; -- user name of current execution context
SELECT session_user; -- session user name
Meaning, session_user shows the role you connected with, and current_user shows the role you are currently operating with, for instance after calling SET role some_other_role;.
answered Mar 19, 2014 at 10:06
Erwin Brandstetter
669k160 gold badges1.2k silver badges1.3k bronze badges
1 Comment
mlt
Just for the sake of completeness, if you want to know a set role from within a function with
SECURITY DEFINER, use current_setting('role') as can be seen on the mailing listYou can check PostgreSQL user permissions with this query:
SELECT * FROM pg_roles;
