Application concerns OVER Login

From: Giacomo (00avoidspam@solsticepoint.com)
Date: 04/05/03 

From: "Giacomo" <00avoidspam@solsticepoint.com>
Date: Sat, 5 Apr 2003 15:30:56 -0500

Help.
1) setup user on network with only user rights. (Win2k Server)
2) gave that user rights to specific stored procedures on database
3) wish to distribute this sql server database on a cd

Question A:

If someone gets a copy of the cd and creates the same user on their network,
will they be able to open the SQL Server 2000 database under that user name
(Windows Authentication) or will they only have rights to the stored
procedures which that user has permission to use (SQL Server
authentication)? As per above, the Windows Authenication Role for this user
is only for the stored procedures. There are no dbo rights for this user.

Question B:

Short of figuring out the sa password, will anyone be able to open that
database on the distributed CD?

Question C:

Is it important to create a difficult password for this user? The password
will be given out with the CD.

I'm not sure if I am doing this correctly.

Giacomo

Relevant Pages

  • Re: Log shipping and error 22029
    ... > Reversing the direction of log shipping is a manual process. ... Promote the secondary database on the Standby server using ... >> After I have run the stored procedures to demote the primary, ...
    (microsoft.public.sqlserver.server)
  • Re: Log shipping and error 22029
    ... do not use the option "Allow database to assume primary role" ... Reversing the direction of log shipping is a manual process. ... Promote the secondary database on the Standby server using ... > After I have run the stored procedures to demote the primary, ...
    (microsoft.public.sqlserver.server)
  • Log shipping and error 22029
    ... I am having some trouble using MS SQL Server 2000 log shipping. ... After I have run the stored procedures to demote the primary, ... detach and attach the database on the secondary to be able to run the stored ... If I don't the procedure fails (sorry, ...
    (microsoft.public.sqlserver.server)
  • Re: Delayed Code Execution?
    ... such as SQL Server for your application? ... I've considered upgrading it to 2005 but always a little nervous about upgrading a production server. ... Each database has no more than, say, 6 tables, with maybe two of them related and the others just lookup tables. ... I've never used stored procedures until recently when I decided to make a few to give them a try, since I heard its the more secure way to go and better performance. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: I need to restrict [database].MDF files using on other MSSQL server. HELP!!!
    ... I have a database named SUTDNet on a server on my computer. ... The thief of data file can ... all user rights for the database on ...
    (microsoft.public.sqlserver.security)