security table in sqlserver 2000

tuoc.le_at_som.com
Date: 07/30/03 

Date: Wed, 30 Jul 2003 11:29:10 -0700

Hi,

If you take away query analyzer and Enterprise Manager,
then no one can have access to that table.

TL

>-----Original Message-----
>I have a table in a database of sqlserver 2000. I want to
protect this table, that mean all user can not modify it
(not rename,addnew or delete all fileds in this table, and
can not see table's structre)by sql server manager or
other ways. How way do it.
>
>
>**********************************************************
************
>Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
>Comprehensive, categorised, searchable collection of
links to ASP & ASP.NET resources...
>.
>

Relevant Pages

  • Re: login security question
    ... Say the password for the Application role is found, can a user access the database through the ... Query Analyser or Enterprise Manager using the application rolde/password.>> ... The user name, however, will be the app role name. ...
    (microsoft.public.sqlserver.server)
  • RE: Strange SQL Server Timeout Problem
    ... > scenario, SELECT statements are successfully processed, but the first INSERT ... > Evan stranger, the situation can be corrected by simply accessing the ... > the database takes much longer than usual, ... > once Enterprise Manager accesses the database, ...
    (microsoft.public.sqlserver.server)
  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
  • Re: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)
  • SQL "Linked Server" to FoxPro problem
    ... If I select more than 1000 record from my FoxPro 5.0 database using ... Query Analyzer or Enterprise Manager I get the following message: ... converting data type DBTYPE_DBDATE to datetime" ...
    (microsoft.public.sqlserver.odbc)