Programming Help

Web Development

Welcome to Dream.In.Code
	Getting Help is Easy! Join 107,663 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,009 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a Expert Register to Make This Box Go Away!

linuxunil	26 Jun, 2008 - 09:25 AM Post #1
New D.I.C Head Joined: 7 Mar, 2006 Posts: 46 Thanked 2 times Dream Kudos: 125 My Contributions	I'm using SQL Server 2005 Express Edition for a project, and want to allow certain users access to a table while keeping others public. I haven't found a way to do this, other than through the front-end. I would like to have it locked at the server level, just because I don't trust my program to be bug free. I have also toyed with the idea of putting the information in a separate database but I need to be able to link it in the main database like you would with foreign keys. Only I still want certain users to be able to view that information. The easiest way to do this may just be look things up by the common keys, but it seems that there has to be a better way.
	This Post Was Helpful! ^New!

Trogdor	26 Jun, 2008 - 11:32 AM Post #2
D.I.C Regular Joined: 6 Oct, 2006 Posts: 443 Thanked 1 times Dream Kudos: 125 My Contributions	afaik there is a good system of userrights in sqlserver. did you try that?
	This Post Was Helpful! ^New!