| Roland Hall 2006-03-17, 2:57 am |
| "Bob and Sharon Hiller" <aoklans@tir.com> wrote in message
news:u6ZYpIVSGHA.2224@TK2MSFTNGP10.phx.gbl...
: Thanks to all who contributed. After a week of struggle I am finally where
I
: needed to be 2 weeks ago. At least I finally have a smile on my face.
:
: It is finally working in VB and ASP. Here is what I did. I created SQL
login
: accounts and re-booted system. They did not work. the sa account did not
: even work. I then changed Authentication back to Windows Only(I did not
: change any account information). Re-booted again. Changed back to SQL
Server
: and Windows Authentication and re-booted again.
: All accounts are now working as expected.
:
: Hopefully, my final question.
: If I want to set up a group of users who can look at one Database and 8 of
: the 16 available tables in that database what permissions should I set?
Please don't top post. This should also be in a new thread and in the db
group. It would give you more opportunity for others to see you have a
second question.
You may need to rephrase because user's should only have access to what your
application allows them to. If you're referring to developers, you're not
restricted to using one account to access a database. You can set
individual permissions on a table for different users, if that's your goal.
--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
|