Securing my Stored Procedures?

Hi,

I have a database that I have created. Currently, I am the only user of
this database. I connect as 'sa'.

Now, I need to move it to a new Company Server.
The logic in the Stored Procedures in my proprietary and I don't want
any body else to be able to view/edit/delete these existing stored
procedures but be able to execute them. I will now have another
programmer adding new ancillary procedures, create new tables write
front-end programs to call my proprietary procedures etc.

Basically, I don't want any body to be able to view my existing
procedures except me. Is this possible? If so, how do I do this? Once
complete, the database will not have many users - 1 or two, hence, one
'sa' account and one, two other accounts will be more than enough.

Thanks.

.

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Take This Value and Shove It
    ... because of the way I must acquire the loan account numbers and borrower ... To get that data into the Access database, and keep it updated, I have ... Your subform record source should be tblNotes or a query based on it. ...
    (microsoft.public.access.formscoding)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)