Search results
A good way around this is to create a view in SCHEMA_B that exposes the table you want to access through the database link. This will also give you good control over who is allowed to select from the database link, as you can control the access to the view.
In this tutorial, you will learn how to use the Oracle GRANT statement to grant SELECT object privilege on one or more tables to a user.
List all users who can SELECT on a particular table (either through being given a relevant role or through a direct grant (ie grant select on atable to joe))? The result of this query should also show through which role the user has this access or whether it was a direct grant.
16 mar 2013 · Oracle Database 23c has extended grant to allow you to give one user access to all tables in another schema: grant select any table on schema table_owner to query_user;
For example, SELECT ANY TABLE allows a user to select data from any table in any schema in the database. Consider the following example. First, log in as jack and select the data from t1 table in the john ‘s schema:
You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL. Syntax. The syntax for granting privileges on a table in Oracle is: GRANT privileges ON object TO user; privileges. The privileges to assign. It can be any of the following values:
Use a SELECT statement or subquery to retrieve data from one or more tables, object tables, views, object views, materialized views, analytic views, or hierarchies. If part or all of the result of a SELECT statement is equivalent to an existing materialized view, then Oracle Database may use the materialized view in place of one or more tables ...
