Viewing 12 posts - 256 through 267 (of 267 total)
quote:
The permissions given back to public:GRANT SELECT on spt_values to publicGRANT EXEC on sp_MSHasDBAccess to public
July 16, 2003 at 2:13 pm
quote:
This is not completely correct. I'll have to dig in my notes, but really you only need access to two objects.
July 16, 2003 at 10:54 am
quote:
- In normal conversation, we don't talk about what rights the guest user has in master and msdb and tempdb when we're...
July 14, 2003 at 5:39 pm
quote:
BTW, I read "You need to have permissions to any database on the server," as having permissions to at least one. ...
July 14, 2003 at 1:06 pm
MOD PARENT UP!
Sorry for the slashdotism, but jpipes is correct:
quote:
...there are 2 correct answers. SiteOwners, please take a look at the...
June 30, 2003 at 9:16 am
It's interesting to me that nobody else seems to have picked up on the fact that the original query will NOT cause a deadlock. You cannot deadlock yourself. ...
June 12, 2003 at 3:58 pm
Not to beat a really, really dead horse, but I think there's another interesting point here.
When I run the following two batches, I DON'T GET A DEADLOCK. I started...
June 11, 2003 at 12:02 pm
This is a great idea. I see that somebody else already posted the same idea, but since this is a democracy <g>, I'd like to reiterate that the request...
June 10, 2003 at 8:38 am
Another problem with autoshrink is simplf that it moves data. You might work very hard to make sure your tables, indexes, etc., get built contiguously only to have autoshrink...
May 5, 2003 at 8:23 am
I'd love to hear more discussion on RAID configuration for databases on a SAN. We have a few relatively new SQL Servers on a SAN here, and right now...
March 26, 2003 at 3:45 pm
quote:
By using global groups, security simply moves with the database. If you used local groups the SIDs would all have to...
February 17, 2003 at 8:53 am
Regarding the comment that db objects are case-insensitive in Oracle: they are not. In fact, Oracle by *default* puts objects into upper-case, both at creation and reference time....
September 23, 2002 at 10:56 am
Viewing 12 posts - 256 through 267 (of 267 total)