Brandie Tarvin

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 9,720 total)

Reply To: Object-level permissions on dbo

Following up on this... Will it hurt if I remove system object permissions from the public role?
Or, alternatively, is there a method to ensure that I only remove user objects...
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

October 4, 2024 at 2:05 pm

#4465313
Reply To: Object-level permissions on dbo

No, it was definately object-level permissions on the public role. I revoked them and my regular account no longer could see the database data.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

October 2, 2024 at 11:39 am

#4464476

Reply To: Object-level permissions on dbo

I'm assuming that it only showed for dbo because it was in public. Because it didn't show for dbo on other databases.

The script I should have used is below:

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

October 1, 2024 at 8:03 pm

#4464324

Reply To: Object-level permissions on dbo

Oh, good grief. My check on public securables finally loaded (I had turned away from it and forgotten to close it after taking that screenshot). Apparently it is public, not...

October 1, 2024 at 7:10 pm

#4464317

Reply To: Object-level permissions on dbo

Script out of user just gives me this:

/****** Object: User [dbo] Script Date: 10/1/2024 2:31:15 PM ******/

CREATE USER [dbo] FOR LOGIN [sa] WITH DEFAULT_SCHEMA=[dbo]

Using this script is where I see...

Attachments:

You must be logged in to view attached files.

October 1, 2024 at 6:38 pm

#4464304

Reply To: Are the posted questions getting worse?

OMG, can I scream yet? This is ... somewhat hilarious and painful and scary all at the same time. Object-level permissions on dbo – SQLServerCentral Forums

HELP!

October 1, 2024 at 4:53 pm

#4464264

Reply To: Dont want to restart Tempdb not able to shrink datafiles in ag primary

Additional note: If TRUNCATEONLY isn't working, check min file sizes on the tempdb files. They may be larger than they are supposed to be. ALTER the files to resize and...

October 1, 2024 at 4:40 pm

#4464260

Reply To: Dont want to restart Tempdb not able to shrink datafiles in ag primary

So there is an alternative if tempdb has "gone wild" and this isn't ordinary growth.

The commands above will help you, as you surmise, but plans will have be recreated and...

October 1, 2024 at 4:39 pm

#4464259

Reply To: SSMS 2016 Default Open + Save Path for Scripts

My workplace has made sure I am unable to update the ssms.Application. pkgdef file to fix my save locations. Very annoying because none of us can make changes in that...