SQL views

  • Comments posted to this topic are about the item SQL views

    Best,
    Naseer Ahmad
    SQL Server DBA

  • Easy one for the day 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • kapil_kk (7/31/2013)


    Easy one for the day 🙂

    +1 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Thanks for the easy one Naseer!

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Thought this was a trick question for a minute!

  • Easy one today, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Easy qotd, but explanation is really confused.

    Schemabinding doesn't hide the definition and users of the database could still view the definition if TDE is enabled.

    Why do you think that Schemabinding should hide the definition of the VIEW?

    TDE encrypts only data on storage, but "database user" can simply see them by a SELECT.

  • This was removed by the editor as SPAM

  • Nice one...

  • Simple and good one....

  • Easy one for the day

  • Nice question and the answer was quite obvious. 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. Also, WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.

    See below for the documentation from MSDN

    [H3]http://msdn.microsoft.com/en-us/library/aa258253(v=sql.80).aspx[/H3]

    WITH ENCRYPTION

    Indicates that SQL Server will convert the original text of the CREATE VIEW statement to an obfuscated format. Note that obfuscated views can be reverse engineered because SQL Server must de-obfuscate views for execution. In SQL Server 2000, the obfuscated text is visible in the syscomments system table and may be susceptible to de-obfuscation attempts.

    Using WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.

  • Just to be clear, in my previous reply, the view definition in syscomments can be de-obfuscated in SQL Server 2000 for those of us who are still having to maintain very old systems that can only be run on SQL 2000. (Yes, we have two applications that our company depends upon that can only be run on SQL 2000). I would love to retire these systems but the powers that be in the company insist that we must keep these systems around because they find them so useful and are "deathly afraid of change".

  • Good question!

  • 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!

Viewing 15 posts - 1 through 15 (of 24 total)

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