Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 security

Author  Topic 

tahseenm
Yak Posting Veteran

64 Posts

Posted - 2006-02-03 : 09:36:40
Hello Everyone,

I would like to get some information that I created a table in SQL Server and I would like to setup some securities such as only me have to have full access and rest of it could have access to the table and input data etc. but not the design of the table etc. Please let me know how to set up this in an easy way. Thanks and you guys are great help always. Thanks!

moetahsen

moetahsen

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-02-03 : 09:40:54
This is a big topic that should really be understood. Have a look at "Managing security" in sql server's Books Online. (Books Online is the Transact-sql help from the Help Menu)

Be One with the Optimizer
TG
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-03 : 09:43:43
Also see if this helps
http://vyaskn.tripod.com/sql_server_security_best_practices.htm
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

tahseenm
Yak Posting Veteran

64 Posts

Posted - 2006-02-03 : 09:52:34
Thanks and I will check on it. Thanks!

moetahsen
Go to Top of Page

tahseenm
Yak Posting Veteran

64 Posts

Posted - 2006-02-03 : 10:08:19
This link below which is sent by you guys is probably going to help me. Thanks and I will read and try to use it. Thanks!

http://vyaskn.tripod.com/sql_server_security_best_practices.htm

moetahsen
Go to Top of Page
   

- Advertisement -