Post reply

Generate Sql Script

  • March 28, 2007 at 1:42 am

    #171875

     

    Thanks for reading this message.I have a User who is having Read/Write permission to a database.User is connecting to Enterprise Manager and running the Generate Sql Script,

    Now the help required from you guys is ...I want to restrict the user for Generating SQL Script from the Enterprise Manager.

     

    Version MSSQL 2000 With Sp3

  • March 28, 2007 at 5:53 am

    #697358

    The permission in SQL Server 2005 is VIEW DEFINITION.

    Note that disabling the user from viewing the definition can have side effects upon apps that depend upon being able to view this information, an example can be seen here http://jagbarcelo.blogspot.com/2006/08/grant-view-definition-permission-to.html

    For SQL Server 2000 I'm not not sure this can be done. See http://msdn2.microsoft.com/en-us/library/ms187113.aspx

  • March 28, 2007 at 6:12 am

    #697361

    SQL 2000 behaved differently than 2005; in 2000, from a logical point of view, if they can read and write a table, they must be able see it's structure as well;so if you give me permission to read the table ,I can directly or indirectly see the sysobjects/syscolumns/sysindexes tables and know how to create the DDL for the table (or use the Generate Scripts function to do it for me)

    can you take away enterprise manager and isql from the user?

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

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