Re: Restricting access to one application and still use database roles?

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Sun, 5 Feb 2006 14:51:13 +0200

Volker

I'm developing a client/server application for SQL Server 2000
manage different access levels within the database/application with
database roles. Furthermore, access to the database should be restricted
to this application.

How do you connect to the database? by WA or Mixed?

"Volker Uffelmann" <uffelmann@xxxxxx> wrote in message
news:ODl$6mFKGHA.344@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

I'm developing a client/server application for SQL Server 2000. I want to
manage different access levels within the database/application with
database roles. Furthermore, access to the database should be restricted
to this application. I understand that I cannot use an application role
for the latter task, because it destroys the database roles.

What can I do now? Any suggestions are greatly appreciated.

Thanks in advance,
- Volker

Follow-Ups:
- Re: Restricting access to one application and still use database roles?
  - From: Volker Uffelmann

References:
- Restricting access to one application and still use database roles?
  - From: Volker Uffelmann

Prev by Date: Re: Is_Member returns 0 with SQL Server Authentication
Next by Date: Re: Restrict user from default tables (access given by public role)
Previous by thread: Restricting access to one application and still use database roles?
Next by thread: Re: Restricting access to one application and still use database roles?
Index(es):
- Date
- Thread

Relevant Pages

Urgent help with sharepoint
... I have an existing website created with classic asp, it has a sequel back ... end database and it has numerous functionalities such as searching, ... Now this website is broken down for 3 different access levels, ...
(microsoft.public.sharepoint.teamservices.caml)
Urgent help needed with sharepoint
... I have an existing website created with classic asp, it has a sequel back ... end database and it has numerous functionalities such as searching, ... Now this website is broken down for 3 different access levels, ...
(microsoft.public.sharepoint.portalserver)
Restricting access to one application and still use database roles?
... I'm developing a client/server application for SQL Server 2000. ... manage different access levels within the database/application with database ... access to the database should be restricted to this ...
(microsoft.public.sqlserver.security)
Re: scope of command and garbage collection
... Dim dtPerson As New DataTable ... database) ... which instanciates the command object, uses it then destroys it, now if i rewrote it like this ...
(microsoft.public.dotnet.languages.vb)
Re: DB_OWNER and the Drop Database issue
... db_datareader,db_datawriter database roles in the BOL ... I have a 3rd party software that needs to create/alter/drop tables within ...
(microsoft.public.sqlserver.security)