Re: Use password

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/10
Message-ID: <3969c0cc@news.iprimus.com.au>#1/1

You may be in deep do-do here, but it is possible to password-protect a role, simply by issuing the command 'Alter role finance identified by secretpassword".

However, I'm almost certain this is not what you want to do. I strongly suggest you read the documentation on users and roles very carefully. The idea behind passwords for roles is that the application has them hard-coded in: you get assurance that the exercise of the privileges associated with the role have been exercised by mean of using the right parts of the application. You get zero reassurance about WHO has exercised the privileges.

Regards
HJR "Cyber" <rthibeau_at_videotron.ca> wrote in message news:yuL95.2919$481.76375_at_wagner.videotron.net...
> 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
>
>
Received on Mon Jul 10 2000 - 00:00:00 CDT