Difference between revisions of "GRANT SELECT ON DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 6: Line 6:
  
 
== Related ==
 
== Related ==
  [[GRANT SELECT]] ON ALL TABLES IN SCHEMA public TO user1;
+
  [[GRANT SELECT ON ALL TABLES]] IN SCHEMA public TO user1;
 
  ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user;
 
  ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user;
  

Revision as of 16:01, 15 December 2022


GRANT SELECT ON DATABASE "yourdbname" to yourusername;
Invalid privilege type

Related

GRANT SELECT ON ALL TABLES IN SCHEMA public TO user1;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user;

See also

Advertising: