Question: how can Oracle access other users’ tables without adding a table user name
Reasons: 1. Convenient access to common tables
2. Hide the users of the table
3. Limit authority
Solution:
1、 Create consent word
CREATE [PUBLIC] SYNONYM synonym_ name FOR [schema.] object[@db_ link];
2、 Create view
create view DF_ YHJB_ BZ as select * from MIS.DF_ YHJB_ BZ
3、 Modify current_ Schema parameter
The schema used to switch the current session. When parsing the object name, if there is no qualified schema name before the object name, Oracle will automatically query the matching objects under this schema.
for example, when the “Scott” user executes the “select * from EMPs;” statement, Oracle will query the “EMPs” table under the “Scott” architecture by default; however, if the “alter session set” current_ Schema = XX; the current schema of the session is changed. When this statement is executed, Oracle will query the EMPs table under XX schema.
Read More:
- Analysis of [error code [942], ora-00942 in synchronization of DDL statements in ogg
- What is the schema in the database?
- 12-web security — error injection based on SQL Server — and, convert, cast
- mysql error 1093
- mysql ERROR 1050 (42S01): Table already exists
- Floor() error injection
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- The solution to the error of [Oracle] ora-00054
- Ctfhub error injection
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- Solve the problem that the interface between C # WinForm program and Oracle doesn’t respond for a long time
- ArcGIS desktop experience. Similar to: error 000732 output Geodatabase
- Solution of Greenplum query calling function error
- 【error】postgresql relation does not exist
- How to Solve mybatis returns null when querying Oracle database with char type field
- Oracle stops a job
- Pg_dump Error: pg_dump: No matching tables were found,pg_dump: schema with OID 1515227 does not exi
- Error 1364 (HY000): field ‘SSL_ cipher’ doesn’t have a default value
- ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS sqlState
- Viewing crontab log of timed tasks in Linux