Re: Help: A difficult request

Don't give the users access to the table directly. Encapsulate the table using a package containing a function that will be accessible by all users, returning details only for the current user.

Bruno

"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1021643917.1728973388@[64.94.198.252]...
> Thanks for all the replies.
>
> What we want is like this:
>
> We want a table which will hold all the username and password for the
> user of the database, we want to have the right of changing the
> password of each user on dba side. Every time we change the password,
> the user has to select the table to get the new password.
>
> So, if user has the username, how can we make sure he can only get the
> password of his own, not the others.(The username is very difficult to
> guess). This is a security issue.
>
> Thanks again for all the helps.
>
>
>
>
>
> --
> Sent by joebayerii from hotmail included in com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Sat May 18 2002 - 22:04:22 CDT