Re: Protecting database structure

paulo
Don't GRANT permissions to the underlauying tables, unstead use EXECUTE
permissions on stored procedures ,or GRANT SELECT on VIEW .

In SQL Server 2005 you have a great feature EXECUTE AS ... please read for
details in the BOL


Alos,perform regular BACKUP on user databases as well as system such
master,msdb,model



"paulo" <isf@xxxxxxxxxxxxx> wrote in message
news:OAgmF1fpGHA.3324@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

We have an application that uses a SQLServer database. We would like to
protect its structure. Is this possible?
Thanks in advance for any help given.

Regards,
paulo


.

Relevant Pages

  • Re: Grant Insert Permission Freezing
    ... Execute sp_who to list current activity. ... Perhaps there is a rogue process blocking your request. ... I kicked everyone out of the database so I am the only ... But when I try to grant permissions to table YYY the ...
    (microsoft.public.sqlserver.security)
  • Re: assigning DB-user to server role
    ... Perhaps if you used profiler while you recreate your scenario in EM (create ... the roles, grant permissions to the role, add users to role, try to execute ...
    (microsoft.public.sqlserver.security)
  • Re: SqlException: EXECUTE permission denied on object
    ... >> Grant permissions to the stored proc to the user who is trying to ... If you don't have Enterprise Manager, you could use the Web Admin tool at ...
    (microsoft.public.dotnet.languages.csharp)