oracle初始登录，创建数据库(user)

初始登录

-- 用sys用户登录
-- ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
sqlplus / as sysdba
sqlplus sys/pwd@orcl as sysdba

-- sqlplus中登录
conn / as sysdba

-- 显示当前用户
show user;
           

创建用户(数据库)、用户授权

-- 创建用户(数据库)
create user user_name identified by pwd;

-- 授予DBA权限
grant dba to user_name;

-- 授予用户选择和删除的权限
grant connect,resource,select,delete on table_name to user_name;