December 19, 2005 at 9:20 pm
Hi all,
I have installed SQL Server and SP4 in Windows Authentication mode, then created Windows users in Security/Login. Also, i've defined roles, configured permissions and removed BUILTIN/Administrators from standard logins. Security works fine in my PC, but tables and SPs will be accessible for all when the DB will be moved to another PC with fresh SQL Server. There is no mean to secure DB only on my PC. Please, let me advise for solving the problem.
Kind regards,
Uugaa
December 21, 2005 at 9:32 am
Securing objects has to be done through maintaining proper previliges on the objects.
We can secure a server in multiple ways and keep the objects inaccessible to unauthorized people.
But when the same objects are moved to another server, we have to impliment the same security policies in the new location also to maintain the security.
On the other side, you can encrypt stored procedures, if you don't want others to mess with them.
December 21, 2005 at 11:04 am
Discussions on how to secure your SQL Server and database will go beyond any forum discussion. Are you trying to secure the database objects? What is the database going to be used for? To support an internal application or one available on the Internet?
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply