Viewing 15 posts - 4,126 through 4,140 (of 6,105 total)
it's a .cmd file and I use shutdown.exe from the Resource Kit, though I'll be switching that to psshutdown because it honors the power down as well. It's manually executed...
July 16, 2003 at 2:52 pm
Right, but everyone belongs to the public role. If he denies to public (as opposed to just revoke), the deny will apply to everyone who isn't a sysadmin.
K. Brian Kelley
http://www.truthsolutions.com/
Author:...
July 16, 2003 at 2:34 pm
quote:
You need tie the permissions of public role if you don't feel comfortable with security in master database.
July 16, 2003 at 1:53 pm
Are you connecting via Windows auth over the linked server connection? If so, are you getting this error coming from a client or from EM on the SQL Server itself...
July 16, 2003 at 1:23 pm
quote:
Would it be a good idea to add guest to db_denydatawriter role in master database?! I wanted to feel safe with that...
July 16, 2003 at 1:21 pm
Are they renaming the domain (using the KB article) or are they doing a side-by-side move to a domain with the proper name?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to...
July 16, 2003 at 12:35 pm
quote:
What would one do if a database started with identity as PK and then years later became larger than expected and ran...
July 16, 2003 at 12:30 pm
Changing to Windows Authentication Only mode won't affect the databases. For instance, when you set up a SQL Server out of the box with Windows Authentication, master, model, msdb, Northwind,...
July 16, 2003 at 12:25 pm
The catch: The problem is, anybody with sysadmin privs can put it back unless you can remove the .DLL, which I don't believe you can. I think some other essential...
July 16, 2003 at 12:16 pm
This isn't directed at Chris or anyone in particular. Need to state that up front. My intent isn't to attack anyone else here, but to point out something that I...
July 16, 2003 at 12:01 pm
From the OpenHack 4 config and with confirmation of Richard Waymire at Microsoft.
quote:
I only know of ONE - the table master..spt_server_info
July 16, 2003 at 11:51 am
quote:
Right 🙂 But I was doing it as a counter-example. You have a 'valid' login but you cannot login. Hence you cannot...
July 16, 2003 at 8:17 am
quote:
There is also the absolute minimum on permissions described.BTW, Brian, have you ever been on http://www.openhack.com ? It seems to be no...
July 16, 2003 at 8:16 am
Look for dSQLSRVD using Google. If you have sysadmin rights to the machine, you can decrypt the stored procedures, triggers, and functions.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL...
July 16, 2003 at 7:47 am
quote:
put Guest into DB_Role db_denydatareader
But this means the login still has access to master....
July 16, 2003 at 7:44 am
Viewing 15 posts - 4,126 through 4,140 (of 6,105 total)