Granting Access To All Tables For A User

In this article, we will examine the methods for granting a user access privileges to all tables in the database.

1. Log in to the database to be authorized.

2. The schemas for which authorization is requested are displayed as follows.

SELECT DISTINCT OWNER FROM SYS.ALL_TABLES;

1	SELECT DISTINCT OWNER FROM SYS.ALL_TABLES;

3. Schemas are selected and written to the WHERE clause section of the query below.

SELECT 'GRANT SELECT ON' || ' ' || OWNER || '.' || TABLE_NAME || ' TO ' || :KULLANICI|| ';' FROM ALL_TABLES 
WHERE OWNER = :ŞEMA;

1 2	SELECT 'GRANT SELECT ON' \|\| ' ' \|\| OWNER \|\| '.' \|\| TABLE_NAME \|\| ' TO ' \|\| :KULLANICI\|\| ';' FROM ALL_TABLES WHERE OWNER = :ŞEMA;

4. Authorization is granted by running the result.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux