yu 用户下
select id from table;
非yu 用户下
select id from yu.table;
select id from table;
非yu 用户下
select id from yu.table;
解决方案 »
- oracle 11g备份
- 【求教】select一个函数的时候,函数参数不能有布尔值吗?
- 表合并问题
- oracle 数据库中怎么获取照片像素
- 存储过程调用SHELL脚本的问题
- oracle(8.1.7)复制支持blod类型吗?
- 请教一个sql语句。多谢!
- 如何对数据库中的表进行截断?请高手指点,非常急,在线等!!!!
- 怎样产生一个以日期命名的日志文件?
- 创建与 Oracle的SQL模型连接时出错:The Network Adapter could not establish the connection
- 数据库关掉连接出错
- 结合两个字段写一个小于where 准备时间 < to_date('12-01', 'hh:mi')select 报错
怎么在SQLPLUS中进入YU用户下?
sys,system和internal这三个用户有什么区别?
所有正规的ORACLE对一个object的名字引用为,schema.object所以要加schema的名字. 但如果你已经在上海市了,就不用问警察上诲市,人民路怎么走了,直接问人民路怎么走就行了.所以当你用yu , login后,可省略schema的名字.如果想省事,可用同意词来实现.
system,也是内建的账号,比sys权限小一些
internal, 是sys的别名
ORACLE is automatically
the password if you
installed your Oracle8
database using the Oracle8
option. If you installed your
Oracle8 database using the
Custom option, the
password is whatever you
entered when prompted
during installation.
DBA user name with which to perform
database administration tasks, including
starting up and shutting down a
database.
Note: INTERNAL is not a true user
name; it is an alias for the SYS user name
and SYSDBA privilege.
Note: INTERNAL uses the SYS schema,
listed below, with additional SYSDBA
privileges. See the chapter "The Oracle
Database Administrator" in Oracle8
Administrator’s Guide for more
information.
SYS/CHANGE_ON_INSTALL DBA user name with the following
database roles:
n AQ_ADMINISTRATOR_ROLE
n AQ_USER_ROLE
n CONNECT
n DBA
n DELETE_CATALOG_ROLE
n EXECUTE_CATALOG_ROLE
n EXP_FULL_DATABASE
n HS_ADMIN_ROLE
n IMP_FULL_DATABASE
n RECOVERY_CATALOG_OWNER
n RESOURCE
n SELECT_CATALOG_ROLE
n SNMPAGENTSYSTEM/MANAGER DBA user name with DBA database role.