July 28, 2008 at 1:22 am
hi all.
i deploy my Appliction and sql database on user pc.
some user have installed enterprise manager on their system. so they easily see my database and can modify it.
i want to configure my sql database to avoid them to expand my database in enterprise manager.
how i can it?
July 28, 2008 at 1:34 am
sepelloo (7/28/2008)
hi all.i deploy my tion and sql database on user pc.
some user have installed enterprise manager on their system. so they easly see my database and can modify it.
i want to configure my sql database to evoid them to expand my databae in enterprise manager.
how i can it?
Have these users got administrator privileges on those machines? If yes, they can do whatever they want, and will be able to get around the restrictions you impose. If they have not got admin privileges, you should be able to restrict their access to the database by permissions (create a database login for these people, a user for the relevant databases, and then grant (http://msdn.microsoft.com/en-us/library/ms187965.aspx)them only the necessary permissions.
Regards,
Andras
July 28, 2008 at 3:36 am
Why are you putting the SQL database onto users PCs? Shouldn't it be on a central server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 3:54 am
tnx.
its a windows based and i should place my database on user pc.all user can access application.
but i heard that sqlserver can use roles to restrict user to expand database.
July 28, 2008 at 4:04 am
But if you put the database on each user's PC, then each user can only see their own information and not anything that anyone else adds/changes.
Is that what you intend?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 4:14 am
i put database on server only.
but i want to user or admin can't see my table or view ,....
July 30, 2008 at 1:50 am
sepelloo (7/28/2008)
i put database on server only.but i want to user or admin can't see my table or view ,....
You may be able to do this, depend on what you want to restrict in the first place. Do you want users to connect to this particular database? Do you want them to be able to select from your tables/views, etc. A good starting point is Books Online, and then read on permissions, the GRANT statement, and roles (there are also some predefined roles available). http://technet.microsoft.com/en-us/library/ms187648.aspx
Regards,
Andras
May 31, 2009 at 3:37 am
Thanks for your replay.
I check it.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply