I have a table that contains passwords and I want the
passwords hidden. MS Access has an input mask for
passwords so they cannot be read. Does SQL server provide
a similar function? Is is possible to store password data
in a table and have it hidden?

Report this post to a moderator

Dave,

You could encrypt it, there are several passwords available.

You could use column level security to block that column.

You could create a view that excludes the column and grant rights to that
view while revoking rights to the table.

Russell Fields
"Dave Wittner" <dlwittner@northropgrumman.com> wrote in message
news:0a2901c29cb3$17565c90$8ef
82ecf@TK2MSFTNGXA04...
I have a table that contains passwords and I want the
passwords hidden. MS Access has an input mask for
passwords so they cannot be read. Does SQL server provide
a similar function? Is is possible to store password data
in a table and have it hidden?

Report this post to a moderator

Hi,

You can use pwdencrypt / pwdencrypt functions.

Example:
select pwdencrypt('123')
select pwdcompare('123',pwdencrypt('1
23'))

Please note, these functions are undocumented and unsupported


Oleg.


"Dave Wittner" <dlwittner@northropgrumman.com> wrote in message
news:0a2901c29cb3$17565c90$8ef
82ecf@TK2MSFTNGXA04...
> I have a table that contains passwords and I want the
> passwords hidden. MS Access has an input mask for
> passwords so they cannot be read. Does SQL server provide
> a similar function? Is is possible to store password data
> in a table and have it hidden?

Report this post to a moderator