Vertica Privilege Queries

Comments

• Adrian_Oprea

  November 2014

  Use this script : 
  SELECT 'GRANT ' || REPLACE(privileges_description, '*', '') || ' ON ' ||       COALESCE(object_schema, '') || '.' || object_name || ' TO ' ||
       grantee || ';' as GRANTS
  FROM v_catalog.grants
 WHERE COALESCE(privileges_description, '') > ''
&nbsp;ORDER BY 1;<BR />
  or go to http://www.verticablog.com/extract-user-privilages-definition-vertica/#.VFt5TPnF8uc
  to get the script
  
  

  0
• Kaushal_Sharma

  November 2014

  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
  
  

  0
• Adrian_Oprea

  November 2014

  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;
  
  

  0