guolihn@sina.com
SYS SYSTEM SYSMAN DBANMP
口令:admin
以下的 J2EE 应用程序已经配置, 并且可用下面列出的 URL 来访问。数据库配置文件已经安装到 D:\oracle\product\10.1.0,同时其他选定的安装组件也已经安装到 D:\oracle\product\10.1.0\Db_1。Ultra Search URL:http://PC-201002070910:5620/ultrasearchUltra Search 管理工具 URL:http://PC-201002070910:5620/ultrasearch/adminiSQL*Plus URL:http://PC-201002070910:5560/isqlplusEnteprise Manager 10g Database Control URL:http://PC-201002070910:5500/em
三个默认的用户:
sys change_on_install
system manager
scott tiger
创建用户:
create user Alfred identified by Alfred;
系统权限:
grant create session to Alfred;
grant create table to Alfred;
grant unlimited tablespace to Alfred;
revoke create session from Alfred;
revoke create table from Alfred;
revoke unlimited tablespace from Alfred;
grant create session to public;
select * from user_sys_privs;
对象权限:
grant select on mytable to Helen;
grant all on mytable to Helen;
revoke select on mytable from Helen;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载