oracle默认账号登录失败Oracle创建用户的方法

创建用户

-- Create the user create user MEP  identified by whq1987  default tablespace MEP  temporary tablespace MEP_TEMP  profile DEFAULT;-- Grant/Revoke role privileges grant connect to MEP;grant datapump_exp_full_database to MEP;grant datapump_imp_full_database to MEP;grant dba to MEP;grant exp_full_database to MEP;grant imp_full_database to MEP;grant resource to MEP;-- Grant/Revoke system privileges grant alter_user to MEP;grant comment any table to MEPoracle账号;grant create any view to MEP;grant create session to MEP;grant create user to MEP;grant delete any table to MEP;grant drop user to MEP;grant export full database to MEP;grant unlimited tablespace to MEP;
此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。