Re: Urgent:deny all users to access the database on another server

From: Kazim Kargi (kkargi@hotmail.com)
Date: 06/23/02 

From: "Kazim Kargi" <kkargi@hotmail.com>
Date: Sun, 23 Jun 2002 10:07:14 -0700

Thanks Linda

It is so interesting that MS Access database can make
protect schema by using mdw but SQL Server not...

I don't to want use Access but unfortunately i have to :(((

>-----Original Message-----
>Kazim,
>
>> I have an application which uses MSDE. This project will
>> install different places. So my mdf file's schema can be
>> copy by another people. I want to make my schema and all
>> data unreachable. My clients only must use the
application
>> for all on database.
>>
>> I deny all the permissions from public users but dbo has
>> the permissions. When i take the database to another
>> computer which has SQL Server, i can attach database and
>> see all tables, views...
>>
>> What can i do to deny another SQL server's sa,dbo and
>> other all users?
>
>sa is an administrator. You cannot deny the sa access to
>your database. You can encrypt stored procedures and
triggers,
>but you cannot encrypt or hide the schema. There is really
>no harm in having administrators look at your schema,
anyway.
>
>If you are concerned about unauthorized changes, write
>a clause into your license agreement stating that the
schema
>cannot be changed and data can only be modified through
>the application.
>
>Linda
>
>
>
>
>.
>

Relevant Pages

  • Re: Need help on how to organize users and objects
    ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
    (microsoft.public.sqlserver.security)
  • xSQL Object 2.5.2.7
    ... synchronizing SQL Server databases. ... Server 2000 database with a SQL Server 2005 database and generate ... history of the schema changes and provide for safe and ... differences, view the scripts of objects, filter results and more; ...
    (comp.software.shareware.announce)
  • Re: SQL Server Express
    ... GRANT CREATE DATABASE on DATABASE::xxx to SAM ... The Windows users have rights because they are administrators. ... "SQL Server and Windows authentication mode".. ... database users, and then define the schema, and this is working. ...
    (microsoft.public.sqlserver.msde)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Re: string from column value
    ... Pro SQL Server 2000 Database Design ... What is wrong with the schema? ... >> Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)