1、系统用户:sys ,system
其他用户:自定义的
2、Oracle用户登录:
Sql>conn user|password@database [as role]
如:conn sys/admin@test as sysdba
3、Oracle的关闭:
Sql>shutdown [immediate][force][normal][tanscational]
如:shutdown immediate
4、连接到空闲例程,然后连接到指定数据库例程:
如:sql>conn sys/admin as sysdba
Sql>startup
5、 创建用户:
Sql>create user name indentified by password default tablespace users Temporary TABLESPACE Temp;
如:create user iamusername identified by iampassword;
授予权限:grant connect,resource to user_name;
6、 删除用户:
Sql>drop user user_name;
7、 锁定用户
Sql>alter user user_name account lock;
8、 为用户解锁
Sql>alter user user_name account unlock;