魔方网表 让信息化更简单

 找回密码
 注册

手机号码,快捷登录

手机号码,快捷登录

查看: 2020|回复: 0

oracle添加用户并指定数据库

[复制链接]
laiye 发表于 2008-7-14 11:16:00 | 显示全部楼层 |阅读模式
imp [email=cmsuser/password@orcl]cmsuser/password@orcl[/email] file=bubp20080708.dmp fromuser=cmsuser touser=cmsuser        SQL> create user uumcuser identified by "password";
        User created.
        SQL> grantgrant connect,dba to uumcuser; SP2-0734: unknown command beginning "grantgrant..." - rest of line ignored. SQL> grant connect,dba to uumcuser;
        Grant succeeded.
        SQL> grant exp_full_database,imp_full_database,resource,create any sequence to cmsuser;
        Grant succeeded.
        SQL> grant create any trigger,create any view,create table,drop any view to uumcuser;
        Grant succeeded.
        SQL> grant exp_full_database,imp_full_database,resource,create any sequence to uumcuser;
        Grant succeeded.
您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archiver|手机版|小黑屋|魔方软件 ( 京ICP备08008787号 )

京公网安备 11010702001722号

GMT+8, 2024-6-10 19:28 , Processed in 0.077852 second(s), 16 queries .

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表