Setting Access rights to DB

Question

Setting Access rights to DB

krishna.kumar

Right there with Babe

Points: 775
More actions
July 29, 2009 at 2:15 am

#203255

Hi All,
I need to make the database installable / accessible to the client -- I want to send them the database file so they can mount it on their sql server BUT I don't want them to be able to access all of the tables. How do i do that ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

Since the SQL Server belongs to the client, the client will have at least one login with SQL Server sysadmin rights, and a sysadmin login cannot be restricted, there is no way to hide any objects.

SQL = Scarcely Qualifies as a Language

Irwan Tjanterik SSC-Addicted Points: 470 More actions · Answer 2

Hi

You can try to utilise databaserole security in SQL Server.

By creating DatabaseRole, e.g. app_operator then you can add the user regardles whether it is SQLusername or ADUsername as a member of this database role.

You willl still need to manually grant access,i.e. SELECT, EXECUTE, UPDATE, INSERT for each tables, stored proces, views, etc.

Good Luck

IT

krishna.kumar Right there with Babe Points: 775 More actions · Answer 3

Hi All,

Thanks for your replies.

The replies from experts will always be a proof to what i have already informed to my client.

Thanks again,

Regards

krishna