Oracle 11g Study Notes (1)

(1)
The Oracle database has a schema not available in other databases, that is, the table created by a user user1, which belongs to the schema of this user. To access other users, you must add the "created user name" to the table, for example:
Select * From user1.table1;

To enable ASP. NET to be online smoothly, the simplest way is to create a table and an online account and use the same oracle user. In this way, you do not need to add the "created user name" before each table in the SQL statement, for example:
Select * From Table1;

Even if the system and SYS users with the highest permission need to read the table created by the general user.

Another solution is to grant the table a "synonym (Synonym; alias)" that everyone can share, for example:
Create public synonym alias name for the user who creates the table. Table Name;
Drop public synonym alias name;

(2)
Grant an oracle user the permission to access one or all tables:
Grant select any table to user;
Grant select on the user who creates the table. The table name to the user name;
Grant all on table name to public;

But this has nothing to do with the schema of (1. In Oracle, even if other users have the permission to read a table created by a user, they still need to add the "created user name" before the table, for example:
Select * From user1.table1;

(3)
Available Oracle online settings for Web. config:

(1) oracleclient and oledb built in Visual Studio:
<Add name = "connstring_oledb_ms" connectionstring = "provider = msdaora; Data Source = 192.168.0.1: 1521/orcl; user id = user; Password = password; Unicode = true; connection timeout = 60"
Providername = "system. Data. oledb"/>

<Add name = "connstring_oracleclient" connectionstring = "Data Source = 192.168.0.1: 1521/orcl; user id = user; Password = password; Integrated Security = no; Unicode = true"
Providername = "system. Data. oracleclient"/>

(2) download from the Oracle Website:
<Add name = "connstring_oledb_oracle" connectionstring = "provider = oraoledb. oracle; Data Source = 192.168.0.1: 1521/orcl; user id = user; Password = password; Unicode = true; "providername =" system. data. oledb "/>

Note that Visual Studio 2005/ADO. NET 2.0 built-in oledb for Oracle cannot correctly display, write special characters and other country text, must use oracleclient, or use ORACLE official oledb to process special characters in Unicode.