SQL views

Question

Post reply

SQL views

Viewing 9 posts - 16 through 24 (of 24 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

Revenant

SSC-Forever

Points: 42467

August 1, 2013 at 9:12 am

#1637823

Thanks for a really easy one, Naseer!

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

Dave62 (8/1/2013)
Thanks for the question.
Here's an interesting read on the use of VIEW DEFINITION permissions instead of encryption.
Options For Hiding SQL Server Code[/url]
Enjoy!

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Miles Neale SSChampion Points: 13147 More actions · Answer 3

Revenant (8/1/2013)
Thanks for a really easy one, Naseer!

And a great reminder as well!

Not all gray hairs are Dinosaurs!

Toreador SSChampion Points: 11386 More actions · Answer 4

Data_God (8/1/2013)
It should be pointed out though that just because you create a view WITH ENCRYPTION, it is still possible for users with the appropriate permissions to see the definition of the view.

Are you sure about that? Which permissions, and how can they see the definition?

Error Handler Ten Centuries Points: 1086 More actions · Answer 5

Error Handler

Ten Centuries

Points: 1086

August 2, 2013 at 8:35 am

#1638203

Thanks Guys...! 🙂

Best,
Naseer Ahmad
SQL Server DBA

udayroy15 Ten Centuries Points: 1077 More actions · Answer 6

By encrypting a view, you help prevent all users (regardless of database privileges), including yourself, from ever seeing the view definition. Thus, you will not be able to alter the view definition. Choose OK to save the view in encrypted form. Choose Cancel to cancel the Save operation.