Clever Geek Handbook

How to restrict table rights to specific tables for a specific custom event, although that user inherits from admin

I have a user called "user1" inherited from admin (who has all access to all tables). Is there a way in postgres to make all tables visible when logged in as admin. But when you are logged in as user1 (although user1 inherited from admin), only the visible few tables need to be visible (so that he can open them, he cannot open a table he cannot see)

+3
sql postgresql postgresql-9.3 roles


source to share


No one has answered this question yet

Check out similar questions:

655
SQL excludes a column using SELECT * [except columnA] FROM tableA?
464
Get the first row of each group
408
SQLite - UPSERT * not * INSERT OR REPLACE
367
How do I select the nth row in a SQL database table?
255
SQL varchar column length guidelines
248
Select n random rows from SQL Server table
17
How can I prevent a user from viewing other databases and tables from other databases?
0
postgreSQL login as a new user created?
0
How to constrain a table to view some tables from Postgres
-1
login as user or administrator from two different tables


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics