Re: Remove access to see database object.
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 10 Dec 2008 15:40:33 -0800
MariaGuzman (maisaguzman@xxxxxxxxx) writes:
Is there is a way I can restrict a user to see the database objects when
is using an application that is not authorized. For example, excel, or
sql tools.
this user is not an it user.
There is no way you can assign permissions per applications. Yes, you
can set up a logon trigger that checks the application name, but that
can easily be forged.
If you only want users to be able to access data through your application,
you need to design or set up the application to cater for that.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Remove access to see database object.
- From: bass_player
- Re: Remove access to see database object.
- References:
- Remove access to see database object.
- From: MariaGuzman
- Remove access to see database object.
- Prev by Date: Re: KB948110 is a problem update and buck is passed by Hotfix suppoty
- Next by Date: Re: KB948110 is a problem update and buck is passed by Hotfix suppoty
- Previous by thread: Re: Remove access to see database object.
- Next by thread: Re: Remove access to see database object.
- Index(es):
Relevant Pages
|
