Viewing 15 posts - 3,796 through 3,810 (of 6,105 total)
There are quite a few products out there that do parts of what you're looking for, but I'm not aware of anything that does the whole kit and kaboodle off...
December 18, 2003 at 11:54 am
Pass-through Windows authentication is possible. However, I believe the user account must be a local account on the SQL Server box itself. If the username/password matches, you're in.
Preferably, though, you...
December 18, 2003 at 11:52 am
If you have a trace running, you can capture the hostname the source passed, but this isn't guaranteed to be accurate. You could also use network traces or an IDS...
December 18, 2003 at 9:03 am
Profiler and the trace stored procedures can also be used to audit logins. I omitted that.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
December 18, 2003 at 8:59 am
All of this is SQL 7.0, someone else will have to comment on SQL 6.5 as I no longer have the docs or a working install.
Look at Books Online for...
December 18, 2003 at 8:58 am
Is it possible to drop a semaphore file that is copied immediately after the actual data file? A 1-byte file or something of that sort. Or is possible to have...
December 18, 2003 at 7:10 am
What are you trying to audit? Just logins? Queries as well? Changes in data?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
December 18, 2003 at 7:08 am
SQL Server 2000 can, here's how:
http://support.microsoft.com/default.aspx?scid=kb;en-us;294453
I don't know of a KB article for SQL Server 7, but you could give the same instructions a try.
As for Yukon, it may be...
December 18, 2003 at 7:06 am
If the view and the tables are in the same database, and they are all owned by the same user (such as dbo), you only have to apply permissions to...
December 18, 2003 at 6:59 am
True, but keep in mind if search suffixes are properly configured on the workstation, it'll append the domain suffix when doing a DNS lookup to find the server. For example,...
December 18, 2003 at 6:51 am
How does the user deposit the file. Is it an automated process? Same file name each time?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
December 17, 2003 at 2:56 pm
Looks like this got posted twice. Continue responses in this thread so we can keep everything together:
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
December 17, 2003 at 2:46 pm
Frank, I have a feeling you will be the first to 2500 between the two of us. ![]()
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL...
December 17, 2003 at 2:42 pm
Yes, views are updateable and have their own sets of permissions. So long as the owners are the same between the views and the base tables, ownership chaining occurs, meaning...
December 17, 2003 at 2:39 pm
Perhaps you can tailor some of the access through views? It's not everything, but you may be able to restrict some access that way.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish...
December 17, 2003 at 2:04 pm
Viewing 15 posts - 3,796 through 3,810 (of 6,105 total)