Oracle Database User Create, Permission Assignment

xiaoxiao2021-03-06  49

1. Database installation parameter settings

The version used below the database is Oracle 9i (

9.2.0

) The operation of Chinese will be more difficult to operate during operation).

2. Database user creation, the allocated database installation is complete, there are two system-level users:

1, the system default password is: Manager

2, SYS default password is: change_on_install

Locate the SQLPlus program in /racle/product/9.2/bin in the installed database directory, run: ./ Sqlplus system / manager @ ora9i

Create your own users with system users; SQL statements are as follows:

1. Create a user:

Create User UserName Identified by PWD Default TableSpace Uses Temporary TableSpace Temp;

2, user authorization

Grant Connect, Resource, DBA to Business;

3, submit

COMMIT;

3. Creating a database with database scripting Using SQLPLUS to log in with the UserName user above, enter: @ Create a script name. SQL Enter, you can create a table, view, stored procedure, etc. in the database. Note: The above creation user procedure can enable the user's table without the N multi-time table generated by the system. Creating a table space SQL: Create TableSpace "msnrobot" Logging DataFile '/opt/ora9/oradata/oracle/msnrobot.dbf' size 10m Extent Management Auto

转载请注明原文地址:https://www.9cbs.com/read-116403.html

New Post(0)