Help: 如何在oracle 9i 中添加1 个user?# Database - 数据库
f*e
1 楼
我最近download oracle 9i 的personal version,但是不知道为什么我只能
用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
thanks.
用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
thanks.
B*e
2 楼
log in "sys", connect as "sysdba", in Oracle Enteriprise Manager( i
remember th personal version has this), u can u anything as the password(but
not blank)
add user by right click security/user
【在 f***e 的大作中提到】
: 我最近download oracle 9i 的personal version,但是不知道为什么我只能
: 用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
: thanks.
remember th personal version has this), u can u anything as the password(but
not blank)
add user by right click security/user
【在 f***e 的大作中提到】
: 我最近download oracle 9i 的personal version,但是不知道为什么我只能
: 用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
: thanks.
m*g
3 楼
login as sysdba (sys)
create tablespaces for this user;
create a profile for this user;
create new user with relevant tablespace and profile;
grant privileges and roles (better start with a dba role)
【在 f***e 的大作中提到】
: 我最近download oracle 9i 的personal version,但是不知道为什么我只能
: 用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
: thanks.
create tablespaces for this user;
create a profile for this user;
create new user with relevant tablespace and profile;
grant privileges and roles (better start with a dba role)
【在 f***e 的大作中提到】
: 我最近download oracle 9i 的personal version,但是不知道为什么我只能
: 用"SYSTEM" 去 log in, 大家说说 我怎么去添加 1 个user?
: thanks.
f*e
4 楼
谢谢大家的指导。
我log in 后用下面的command 对吗？
SQL> CONNECT SYS/change_on_install AS SYSDBA
然后用什么command 去 create tablespace?
【在 m******g 的大作中提到】
: login as sysdba (sys)
: create tablespaces for this user;
: create a profile for this user;
: create new user with relevant tablespace and profile;
: grant privileges and roles (better start with a dba role)
我log in 后用下面的command 对吗？
SQL> CONNECT SYS/change_on_install AS SYSDBA
然后用什么command 去 create tablespace?
【在 m******g 的大作中提到】
: login as sysdba (sys)
: create tablespaces for this user;
: create a profile for this user;
: create new user with relevant tablespace and profile;
: grant privileges and roles (better start with a dba role)
m*g
5 楼
according to Oracle Admin Guide, it is like: (you need to tweak some
paths, names and sizes)
paths, names and sizes)
相关阅读
Access database sizeoracle problemsMS SQL Server 2k questionwho has desktop or standard version of sql2k?Re: Use Access Link table to h use SQL server tables.FileMaker Prolost half years post?Help need on writing data to Oracle CLOB!wuwu... I hate doing this...在win2000+sql server 2000中怎么加入中文?Problem Running MySql on W2KMy SQL and Crystal reportwhere to find Oracle adm's handbook, developer guide BOOK?USE statement in SQL 7who knows a good data mining software freeHELP!! How to run SQL Server 7 in my local computer?Re: JDBC and embedded SQL programming问一个关于mysql的问题Re: SQL crash, HELP!!How to change Default Buffer Size for Long Columns?(string size exceeds 1K)