Post reply

MINIMUM SECURITY REQUIRMENTS TO GENERATE SCRIPTS

  • August 3, 2006 at 2:26 pm

    #75033

    What are the minimum requirements a database use must have in order to be able to generate scripts of a database or database objects using EM?

  • August 4, 2006 at 7:22 am

    #653314

    the public role is sufficient to give the user access to create the DDL for any table/view/proc;

    I just created a new user and gave them the public role to a database. if I connected as that user via Query analyzer, I could see that database, plus the standard public databases like master,pubs,northwind,tempdb and msdb.

    other databases do not appear in QA.

    from QA, I could generate the DDL, or run a query that generates the DDL based on sysobjects/syscolumns.

    used the same user to connect via EM, and could see every database on the server...is that because the master database is public, and thus the contents sysdatabases is visible?

    when i tried to expand Tables on a database that this user did not have access to, i would get the error 916: Server user 'testuser' is not a valid user oin database 'XXX', but the one database that i added the user to the public role to was able to generate scripts for every object int eh database...procs, functions, tables, views, whatever.

     

    HTH

     

    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 2 posts - 1 through 1 (of 1 total)

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