Difference between revisions of "GRANT"

From wikieduonline
Jump to navigation Jump to search
Line 20: Line 20:
  
 
* [[View GRANTs on Redshift]]
 
* [[View GRANTs on Redshift]]
 +
* [[Amazon Redshift: show permissions]]
  
 
== Related terms ==
 
== Related terms ==

Revision as of 09:55, 10 December 2021

Example:


GRANT your_defined_role TO your_username;
GRANT ROLE
SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name
GRANT SELECT ON mytable TO xxx
  • List roles: \du

Related terms

See also

  • https://stackoverflow.com/a/10353730
  • https://dba.stackexchange.com/a/184339
  • Advertising: