database - PGAdmin permission denied -


someone created database , super user in pg admin. when tried access database tables clicking on it, received error message "permission denied relation table_name". it's table mayan database. tried kinds of methods, unfamiliar , not sure how go doing it. opened sql editor , entered grant commands grant myself access, keep getting "permission denied". using pg admin.

can tell me how can granted access table?

to access table have grant privileges tables grant. first enter database , open sql editor execute 1 of next queries:

-- privileges grant privileges on tables in schema public user  -- viewing privileges grant select on tables in schema public user 

note have specify schema.


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -