Difference between revisions of "GRANT SELECT ON DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 6: Line 6:
  
  
−
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;
  
 
== See also ==
 
== See also ==

Revision as of 15:38, 15 December 2022


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



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

See also

Retrieved from "https://www.wikieduonline.com/index.php?title=GRANT_SELECT_ON_DATABASE&oldid=209019"

Advertising: