Sql

Search

Grant read-only privilleges to the user

GRANT CONNECT ON DATABASE wsh TO <username>;
GRANT USAGE ON SCHEMA public TO <username>;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <username>;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO <username>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <username>;

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle factorial
Sql :: how to check if there is no database schema
Sql :: SQL Backup Only New Changes in SQL
Sql :: sql select in where clause for when more than one records exists
Sql :: multiple value select mysql
Sql :: ring close the connection to the database using the odbc_disconnect()
Sql :: kie business put user infos in database
Sql :: sqlalchemy sequence postgresql
Sql :: ora 00001 in oracle
Sql :: python and mysql connectivity
Sql :: Rows, INSERT INTO
Sql :: while in plsql
Sql :: mysql order by desc
Sql :: in condition in sql
Sql :: sqlite describe table
Sql :: flask sqlalchemy session delete
Sql :: sql id serial primary key
Sql :: how to subquey to do not load in live database in
Csharp :: c# messagebox yes no
Csharp :: unity how to change max fps
Csharp :: c# get username
Csharp :: loop through an enum c#
Csharp :: convert string array to int c#
Csharp :: OnInitialized blazor
Csharp :: unity set object scale
Csharp :: print out a dictionary c#
Csharp :: how to do a foreach loop in c# for dictionary
Csharp :: convert timestamp to datetime c# code
Csharp :: c# check if list contains string case insensitive
Csharp :: wait in unity

Search

SQL

Grant read-only privilleges to the user

ADD CONTENT