hi,(sqlserver 2005 and sqlserer 2008 r2 express)

            I have to give my database to some body he has his own server, i do not want him to see my stored porcs code and/or name , and tables schema.

           I have used encryption to that,

but i think , there is some code available on internet , which can be used to get the code from stored procs,

please tel me how i can i accomplish the task.

yours sincerely

Hello,

Stored procedure / user defined function can be encrypted; but with a hack you may get them decrpyted as well.

For table and views there is no such Option available.

You may also create a user group with select permission on certain tables or all tables and put him in to the group. He may see the tables & other objects like SP & functions, but cannot read anything from it.

You may create a view which would get/contain the info required for your client.

And create a login in your server and provide access only to the view and share the login to your client.

This way you can restrict others from seeing your procedures and other objects.

iIhave given that database backup (.bak) to some body, he has his own sqlserver instance, and a machine,

will he be able to grant/denay permissions , if yes then he can see my SP.

-- At least he will be having "sa" for his instanace .

-- Can table schema be encrypted?( I know data can be encrypted)

yours sincerly

• Edited by rajemessage 5 hours 49 minutes ago

iIhave given that database backup (.bak) to some body, he has his own sqlserver instance, and a machine,

will he be able to grant/denay permissions , if yes then he can see my SP.

-- At least he will be having "sa" for his instanace .

-- Can table schema be encrypted?( I know data can be encrypted)

yours sincerly

He will be able to grant,deny permissions if his login is a member of securityadmin server role

When you are giving backup file of your database to 3rd party.It means you are literally giving him everything in the database.you can't restrict him from viewing the database objects

Hi Rajemessage,

Instead of going though all this, why can't you can create temporary database from original database , push object and data that is required(Subset of the original database). 

Set this is as process(Job) for before transfering the database. 

Take the backup of this temporary database  and provide to the user.

However, this 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

iIhave given that database backup (.bak) to some body, he has his own sqlserver instance, and a machine,

will he be able to grant/denay permissions , if yes then he can see my SP.

-- At least he will be having "sa" for his instanace .

-- Can table schema be encrypted?( I know data can be encrypted)

yours sincerly

• Edited by rajemessage Friday, March 28, 2014 4:40 AM

before you create the backup run the following command:

deny view definition to public

create the backup, run the following command:

grant view definition to public