Vertica Privilege Queries
Hi i am totally new to vertica. I want to know if i have create privilege to create objects(tables,schema,sequence) in vertica. What is the query we use to view this
Use this script :
or go to http://www.verticablog.com/extract-user-privilages-definition-vertica/#.VFt5TPnF8uc
to get the script
SELECT 'GRANT ' || REPLACE(privileges_description, '*', '') || ' ON ' || COALESCE(object_schema, '') || '.' || object_name || ' TO ' || grantee || ';' as GRANTS FROM v_catalog.grants WHERE COALESCE(privileges_description, '') > '' ORDER BY 1;<BR />or go to http://www.verticablog.com/extract-user-privilages-definition-vertica/#.VFt5TPnF8uc
to get the script
this is same as select * from grants
but when i fire this query it gives information about a role...so the next the question is how to derive the role description
but when i fire this query it gives information about a role...so the next the question is how to derive the role description
Try this
http://www.verticablog.com/extract-roles-definition-vertica/#.VFuHPfnF8uc
SELECT 'CREATE ROLE ' || name || ' ;' AS ROLESFROM v_catalog.roles
WHERE name NOT IN ('public', 'dbadmin', 'pseudosuperuser', 'dbduser')
ORDER BY 1;
http://www.verticablog.com/extract-roles-definition-vertica/#.VFuHPfnF8uc
SELECT 'CREATE ROLE ' || name || ' ;' AS ROLESFROM v_catalog.roles
WHERE name NOT IN ('public', 'dbadmin', 'pseudosuperuser', 'dbduser')
ORDER BY 1;
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
