How to integrate Access application security with a SQL Server security 
Author Message
 How to integrate Access application security with a SQL Server security

I have a SQL Server database with the Access front end. If I have an
application level security, how can I integrate with the SQL Server
security. That means if the user log into the Access application, how
can I know if he/she is an System Administrator or general user for the
SQL database?
Thanks.
Rong



Tue, 17 Oct 2000 03:00:00 GMT
 How to integrate Access application security with a SQL Server security

1. You can create Access security groups which correspond to the SQL groups.
In VBA you can determine  the group membership of the logged on user.
(CurrentUser())

2. Attempt to access an object you know a non-SA user doesn't have
permissions to and trap the resulting error.

3. Use a trusted connection, which will map domain logons(not Access logons)
to SQL groups. Then you can dispense with the Access Security.

Quote:
>I have a SQL Server database with the Access front end. If I have an
>application level security, how can I integrate with the SQL Server
>security. That means if the user log into the Access application, how
>can I know if he/she is an System Administrator or general user for the
>SQL database?



Wed, 18 Oct 2000 03:00:00 GMT
 How to integrate Access application security with a SQL Server security

In regards to the original post, I really hope you don't plan to make users SA.
I could
see making a couple DBO's but certainly NOT SA. This would open the door to
mayhem
and I wouldn't want to have to deal with that.

Francis


Quote:
> 1. You can create Access security groups which correspond to the SQL groups.
> In VBA you can determine  the group membership of the logged on user.
> (CurrentUser())

> 2. Attempt to access an object you know a non-SA user doesn't have
> permissions to and trap the resulting error.

> 3. Use a trusted connection, which will map domain logons(not Access logons)
> to SQL groups. Then you can dispense with the Access Security.

> >I have a SQL Server database with the Access front end. If I have an
> >application level security, how can I integrate with the SQL Server
> >security. That means if the user log into the Access application, how
> >can I know if he/she is an System Administrator or general user for the
> >SQL database?



Fri, 20 Oct 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. XMLBulkLoad Works with integrated security, fails with SQL Server security

2. NT Integrated Security Without SQL Security Manager ?

3. Integrated security with Access and SQL Server

4. Application Access with Integrated Security Model

5. Integrated Security & Security Manager

6. Integrated Security & Security Manager

7. change from integrated security to nt only security

8. Changing from Standard security to Integrated security

9. How to connect to SQL Server through ADO (SOL Server uses Integrated Security)

10. How to connect to SQL Server through ADO (SOL Server uses Integrated Security)

11. COM+ and SQL Server; COM+, SQL Server, and Integrated Security; Integrated Security [Solved :-)]

12. Linked tables: Access 97 to SQL 7.0, Integrated Security


 
Powered by phpBB® Forum Software