Difference between revisions of "GRANT SELECT ON DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 5: Line 5:
 
  [[Invalid privilege type]]
 
  [[Invalid privilege type]]
  
 
+
== 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 15:41, 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: