GRANT

From wikieduonline
Revision as of 09:51, 26 January 2023 by Idontknowmaths (talk | contribs)
Jump to navigation Jump to search

Examples

  • SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE
GRANT USAGE
GRANT USAGE ON ALL SEQUENCES IN SCHEMA your_schema TO mygrp; [1]

Command: GRANT "your-defined_role" TO "your_username";

Output: GRANT ROLE
SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name
psql -h you_dp_ip -U postgres -p 5432  << EOF
CREATE DATABASE "yourdbname";
CREATE USER "yourusername" WITH PASSWORD yourpassword;
GRANT ALL PRIVILEGES ON DATABASE "yourdbname" to "yourusername";
GRANT ALL PRIVILEGES ON SCHEMA public to "yourusername";
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "yourdbname";
EOF


GRANT CONNECT

Amazon Redshift

Amazon Redshift system information functions:

AWS RDS

Activities

Related terms

\dt *.*

See also

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