如何创建Oracle新用户（新schema）

Oracle中创建新的user, 也就相应地创建了一个新的schema, 用来区别其他目录的同时, 还保存所有相关user的数据对象以及user的表. How to create a new user？（create a new db）首先用system（默认密码为manager）用户登陆连接数据库. The statement create user creates a user.
In the most simple form, the create user statement is one of the following three:

create user alfredo identified by alfredos_secret;
create user alfredo identified externally;
create user alfredo identified globally as "external_name";

The first one creates a local user, the second one creates an external user while the last one creates global user.How to create locked users？A user can be created locked, that is, the user cannot connect to the database.SQL> create user alfredo identified by passw0rd account lock;The user is now created, he can be granted some rights, for example the right to connect to the database: SQL> grant connect to alfredo; Now, if the user tries to connect to the database, he will get ORA-28000:

SQL> connect alfredo/passw0rd
ERROR:
ORA-28000: the account is locked

The user can now be unlocked with an alter user statement: SQL> alter user alfredo account unlock; Which allows Alfredo to log on to the database now:

SQL> connect alfredo/passw0rd
Connected.

Ant中执行Oracle存储过程MySQL导入数据非常慢的解决办法相关资讯 Oracle存储过程

Oracle存储过程拼接in语句 & 自定（今 09:21）
【PL/SQL系列】Oracle存储过程使用（04月23日）
Oracle存储过程及Java调用（05/28/2015 20:29:33）

Java调用Oracle存储过程返回多条结（04月29日）
Oracle中的存储过程简单应用（04月10日）
判断点是否落在面中的Oracle存储过（05/09/2015 09:39:30）

本文评论查看全部评论（0）

评论声明

尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任