Statement level permissions T-SQL Search

Question

Post reply

Statement level permissions T-SQL Search

Brandie Tarvin

SSC Guru

Points: 173108
More actions
January 10, 2008 at 5:43 am

#177915

This is annoying.
BOL doesn't have any topics that I can find on granting statement level permissions with T-SQL. In fact, I had to go to the SQL 2000 BOL to find a reference and it pointed me to the GUI.
The only T-SQL permissions I could find in BOL 2k5 was granting object permissions or securable permissions.
Has anyone else been able to find this topic in BOL 2k5? I've got the latest version of BOL and can't find it no matter what topic I search on. BLEARGH!
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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 1

Do you mean this?

http://msdn2.microsoft.com/en-us/library/ms178569.aspx

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 2

Brandie Tarvin (1/10/2008)
This is annoying.
BOL doesn't have any topics that I can find on granting statement level permissions with T-SQL. In fact, I had to go to the SQL 2000 BOL to find a reference and it pointed me to the GUI.
The only T-SQL permissions I could find in BOL 2k5 was granting object permissions or securable permissions.
Has anyone else been able to find this topic in BOL 2k5? I've got the latest version of BOL and can't find it no matter what topic I search on. BLEARGH!

These are grouped under database permissions

http://msdn2.microsoft.com/en-us/library/ms178569.aspx (assuming the we mean the same under statement level permissions. I mean the CREATE FUNCTION, CREATE PROCEDURE ... permissions :))

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

Yes, that's what I was looking for, but couldn't find it because I was looking in BOL under "Table" instead of "Database".

And in BOL 2000, they actually list "statement" as a topic, but not in 2k5 BOL.

Thanks, Guys.

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.