Re: Oracle Free 90 days trial problem

From: PT <100256.3626_at_CompuServe.COM>
Date: 1995/06/17
Message-ID: <3ruiat$4c4$2_at_mhadf.production.compuserve.com>#1/1


You can create new database users by going into SQLPLUS and typing :
GRANT <privilege> to <username> identified by <password>

The username and password can be chosen by you. The privilege can be one of the following:

  1. CONNECT - allows users to connect to the database, select and change data but won't allow them to create tables. Generally useful for the basic users of a system.
  2. RESOURCE - allows users to connect, change data and create database objects (tables, indexes, etc).
  3. DBA - allows users to add tablespaces create other users, create database object, modify any data in the database(even that of other users). This is the highest level of database privilege.

Hope this helps,
PT Received on Sat Jun 17 1995 - 00:00:00 CEST

Original text of this message