Re: DataBase security

From: BP Margolin (bpmargo@attglobal.net)
Date: 02/10/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Mon, 10 Feb 2003 15:28:05 -0500

Rushi,

Do you want to allow non-SysAdmin users access to the database only through
an application?

If so, check out the documentation on "application roles" in the SQL Server
Books Online.

Please note, that using application roles will probably require some
reprogramming of your application.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Rushi" <patelrushi121@rediffmail.com> wrote in message
news:006f01c2d12b$5c10a9b0$d5f82ecf@TK2MSFTNGXA12...
> hi,
>
> I had developed a software with sqlserver as a backhand.
> The problem i am facing is that i am unable to secure
> my database. I had very little idea abt database security.
>
> I wish that no one except system administrator could access
> database either through Enterprise Manager or Query
> Analyzer.
>
> Awaiting a quick respone
>
> Thanking you
> rushi

Relevant Pages

  • Re: Stupid Question - I think!
    ... I know that the table was not updated because I go to the Query Analyzer on ... update statement shown below does run in the Query Analyzer on the PDA ... (against the CE database) ... "Earl" wrote: ...
    (microsoft.public.sqlserver.ce)
  • Strange SQL Server CE 2.0 Problem
    ... Server CE database that is stored on a flash card inside the device. ... I can't use the SQL CE Query Analyzer -- the device ... selectCommand = new SqlCeCommand(sql, _connection, transaction); ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database file already opened when synchronizing
    ... user had the Query Analyzer open in a background window) because the user ... usually would not be aware of that limitation. ... > SQL CE databases are limited to a single open connection at any ... >>I have noticed that if a PocketPC Query Analyzer has the database opened ...
    (microsoft.public.sqlserver.ce)
  • Re: sqlserver and access
    ... solid on exactly what SQL Server is. ... Query Analyzer is simply a tool that allows an administrator/developer to ... Your "central main database system" is actually a SQL Server. ... or would I need the help of a network administrator? ...
    (microsoft.public.sqlserver.programming)
  • Re: Project
    ... but this example (that you can run within Query Analyzer) should get you started: ... I am totally new to SQL/VB6.0> I need to create a lookup scenario for end users to search the database by name or zipcode. ... > Since the user will have no knowledge of writting SQL queries, I would like to create a data entry screen for the user to enter the zipcode or name and have the database queried by that input. ...
    (microsoft.public.sqlserver.programming)