Re: Password MDF

Hi Uri,

Thank you for your answer but it doesn't work because I can connect to SQL
Server 2005 Management Studio with Windows Authetication and I still see
"dbteste" database and all his objects, so if I distribute this database
with a desktop application and one user has SQL Server 2005 Management
Studio, this user will see all exiting data.

Best regards


"Uri Dimant" <urid@xxxxxxxxxxx> escribió en el mensaje
news:OM2HiRlFIHA.1324@xxxxxxxxxxxxxxxxxxxxxxx
Hi
It works perfectly if the user is the owner of the database. Look
that .

. Create a new SQL login "login1"
. Create a user named "login1" in master database
. Grant CREATE DATABASE to login1
. While impersonating login1, create a database called "dbteste"
. Revoke CREATE DATABASE permission from login1
. Revoke VIEW ANY DATABASE permission from PUBLIC
. Register this server as login1
. From the "login1" session, expand database tree. Now, you should see
master, tempdb, dbteste
. Grant VIEW ANY DATABASE to PUBLIC
. From the "login1" session, you should see all the databases




"Julián Sanz García" <jsanz@xxxxxxxxxxxx> wrote in message
news:upUufJlFIHA.3672@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

¿Are there any way to protect a database that is reditributed with a
desktop application? I want to protect this database with an user and a
password, something like access, but with SQL Server 2005, if you have
SQL Server 2005 Management Studio, you can access without any problems
and you can see all database objects.

Thanks a lot





.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)