Differences

This shows you the differences between two versions of the page.

--- resources [2011/11/28 21:39] – [Admin SQL] k2patel
+++ resources [2020/08/10 02:35] (current) – external edit 127.0.0.1
@@ Line 62: / Line 62: @@
 == Read Only User ==
-This only allow user to access database but can not write to it.
+This only allow user to access database but can not write to it.\\
-**NOTE : Before you grant make sure you selected database else it could not work**
+<note important>Before you grant make sure you selected database else it could not work</note>
 <code sql>
@@ Line 70: / Line 70: @@
 GRANT SELECT ON ALL TABLES IN SCHEMA public TO carol;
 </code>
+<note tip>If there is ERROR : pg_dump: The command was: LOCK SEQUENCE public.client_group IN ACCESS SHARE MODE See next Section </note>
+<code sql>
+\dp public.client_group; # check permission
+GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO backup;
+</code>
+<note tip>Even you can use above commands to create backup user for specific database.</note>
 ==== Getting Connection Information ====