Re: Use password

From: <maaher_at_my-deja.com>
Date: 2000/07/10
Message-ID: <8kbqed$2gv$1@nnrp1.deja.com>#1/1

A role is a set of privileges, it is NOT a user. So you have to create a user, which is identified by its password: SQL> CREATE USER <your_user> IDENTIFIED BY <your_password>;

Then, in order to make all the privileges available to this user, you grant the role to this user.

Greetz,
Maarten

In article <yuL95.2919$481.76375_at_wagner.videotron.net>, "Cyber" <rthibeau_at_videotron.ca> wrote:
> I want to give a password to user in sql+
> how do that , please?
> I create role finance
> I grant connect and resource
> How create password to finance
>
> Think you ... Cyber
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 10 2000 - 00:00:00 CDT