*** Urgent Retrieve UID

3 Aug 2006 9:29 PM

Me

I am relying on Sql Server Security for linked tables in Access.

Now I have a need to know the UID of the user logged on. How can I get it?
Based on this UID, I want to restrict access to certain records.

Thank you,
-Me

4 Aug 2006 9:17 AM

Chris Mills

CurrentUser() retrieves the current Username.

If you want the password, I don't think that's retrievable. If it was,
SQLServer would hardly be secure with Access as a Front End.

You need to be real carefull. Depending on how you implement Access as a Front
End, you could potentially bypass all security you have setup in SQLServer.

In Access, RWOP Queries (Run With Owner Permission) may be what you're looking
for. They are only as secure as Access User-Level Security.

Chris

Show quoteHide quote

"Me" <M*@discussions.microsoft.com> wrote in message
news:B441FFDB-25A5-48A0-BACC-CD8A0D1C8241@microsoft.com...
> I am relying on Sql Server Security for linked tables in Access.
>
> Now I have a need to know the UID of the user logged on. How can I get it?
> Based on this UID, I want to restrict access to certain records.
>
> Thank you,
> -Me
>

4 Aug 2006 3:49 PM

Me

Hi Chris,

Thanks for the reply!

For some reason, the CurrentUser shows the Access userid. It doesn't show
Sql Server Userid with which I am logging on. What I may be doing wrong?

Moreover, I don't want password, I just need the SQL server UID.

Thank you again for your help in advance,
-Me

Show quoteHide quote

"Chris Mills" wrote:

> CurrentUser() retrieves the current Username.
>
> If you want the password, I don't think that's retrievable. If it was,
> SQLServer would hardly be secure with Access as a Front End.
>
> You need to be real carefull. Depending on how you implement Access as a Front
> End, you could potentially bypass all security you have setup in SQLServer.
>
> In Access, RWOP Queries (Run With Owner Permission) may be what you're looking
> for. They are only as secure as Access User-Level Security.
>
> Chris
>
> "Me" <M*@discussions.microsoft.com> wrote in message
> news:B441FFDB-25A5-48A0-BACC-CD8A0D1C8241@microsoft.com...
> > I am relying on Sql Server Security for linked tables in Access.
> >
> > Now I have a need to know the UID of the user logged on. How can I get it?
> > Based on this UID, I want to restrict access to certain records.
> >
> > Thank you,
> > -Me
> >
>
>
>

6 Aug 2006 12:34 AM

Chris Mills

Hi Me,

I don't know. Hopefully someone else will answer who's more familiar with
SQLServer.

Either the name you pass to SQLServer is stored (or can somehow be retrieved)
when Access signs onto SQLServer, or perhaps there's a way to recover from
SQLServer.

For the second option, I don't know. And for the first option, I don't know
what your Access program does.

Chris

Show quoteHide quote

"Me" <M*@discussions.microsoft.com> wrote in message
news:5261238A-C8BF-4F91-94A6-C1D63B53BCD0@microsoft.com...
> Hi Chris,
>
> Thanks for the reply!
>
> For some reason, the CurrentUser shows the Access userid. It doesn't show
> Sql Server Userid with which I am logging on. What I may be doing wrong?
>
> Moreover, I don't want password, I just need the SQL server UID.
>
> Thank you again for your help in advance,
> -Me
>
>
>
>
> "Chris Mills" wrote:
>
> > CurrentUser() retrieves the current Username.
> >
> > If you want the password, I don't think that's retrievable. If it was,
> > SQLServer would hardly be secure with Access as a Front End.
> >
> > You need to be real carefull. Depending on how you implement Access as a
Front
> > End, you could potentially bypass all security you have setup in
SQLServer.
> >
> > In Access, RWOP Queries (Run With Owner Permission) may be what you're
looking
> > for. They are only as secure as Access User-Level Security.
> >
> > Chris
> >
> > "Me" <M*@discussions.microsoft.com> wrote in message
> > news:B441FFDB-25A5-48A0-BACC-CD8A0D1C8241@microsoft.com...
> > > I am relying on Sql Server Security for linked tables in Access.
> > >
> > > Now I have a need to know the UID of the user logged on. How can I get
it?
> > > Based on this UID, I want to restrict access to certain records.
> > >
> > > Thank you,
> > > -Me
> > >
> >
> >
> >

6 Aug 2006 1:52 PM

blue rose

not see you
Show quoteHide quote

"Me" <M*@discussions.microsoft.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:B441FFDB-25A5-48A0-BACC-CD8A0D1C8***@microsoft.com...
>I am relying on Sql Server Security for linked tables in Access.
>
> Now I have a need to know the UID of the user logged on. How can I get it?
> Based on this UID, I want to restrict access to certain records.
>
> Thank you,
> -Me
>