Re: Urgent:deny all users to access the database on another server
From: Morris Lewis (Morris@Holistech.com)
Date: 07/01/02
- Next message: FR: "Re: To deteremine NT logins + Sql Logins with sa + dbo + prviliges"
- Previous message: Morris Lewis: "Re: Change username of "SA""
- In reply to: Kazim Kargi: "Re: Urgent:deny all users to access the database on another server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Morris Lewis" <Morris@Holistech.com> Date: Mon, 1 Jul 2002 00:32:18 -0500
Access is a single user database at its heart. SS was designed from the
beginning to be a multiuser, multi-database server. Sysadmin must have
unrestricted access to the server to be able to perform all the tasks an
admin has to perform. Dbo must have similar rights within the database. The
system doesn't work is they don't.
Send in a request to the SS development team. Maybe they can figure out a
way to do something in Yukon.
Morris Lewis
MCDBA, MCSD, MCSE+I, MCT, CTT+
President, Holistech Inc.
"Kazim Kargi" <kkargi@hotmail.com> wrote in message
news:11beb01c21ad8$6c18d4e0$3bef2ecf@TKMSFTNGXA10...
> 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
> >
> >
> >
> >
> >.
> >
- Next message: FR: "Re: To deteremine NT logins + Sql Logins with sa + dbo + prviliges"
- Previous message: Morris Lewis: "Re: Change username of "SA""
- In reply to: Kazim Kargi: "Re: Urgent:deny all users to access the database on another server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
