oracle怎样创建scott用户,oracle 手工创建Scott用户

oracle 手工创建Scott用户

1.登录数据库

sqlplus / as sysdba

2.创建scott用户

create user scott identified by tiger;

3.为scott用户分配权限

grant connect,resource to scott;

4.用scott用户登录

conn scott/tiger

5.执行demobld.sql脚本，脚本内容是:

----------------------demobld.sql begin-----------------------

--

-- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.

--

-- NAME

-- demobld.sql

--

-- DESCRIPTION

-- This script. creates the SQL*Plus demonstration tables in the

-- current schema. It should be STARTed by each user wishing to

-- access the tables. To remove the tables use the demodrop.sql

-- script.

--

-- USAGE

-- From within SQL*Plus, enter:

-- START demobld.sql

SET TERMOUT ON

PROMPT Building demonstration tables. Please wait.<