Post reply

Web Assistant privileges Privileges

  • March 29, 2004 at 3:12 am

    #84856

    I want a normal user to get Web Assistant Wizard running in the Wizards tool box.

    Though i have given the execute rights on all the three system stored procedures.

    sp_makewebtasks, sp_runwebtask, sp_dropwebtask.

    Then also a login who is a dbo owner in some databases and having execute privileges doesnt get Web Assistant Wizard in the Wizards Dialog box.

    This wizard can be seen through sa login only.

    Can someone let me know what privileges needs to be given to a user for accessing Web Assistant Wizard

  • March 29, 2004 at 6:37 pm

    #500983

    From SQL BOL

     

    Configuring the Web Assistant Wizard

    Before running the Web Assistant Wizard, you must:

    • Set appropriate permissions.
    • Choose the database to publish.
    • Create queries.

    Setting Permissions

    To run the Web Assistant Wizard, you must have:

    • CREATE PROCEDURE permissions in the selected database.
    • SELECT permissions on chosen columns.
    • Permissions to create files in the account in an instance of Microsoft® SQL Server™.

    Choosing the Database to Publish

    The Web Assistant Wizard works with databases created by SQL Server. Select the database to publish in the console tree of SQL Server Enterprise Manager. If the server does not appear in this list, run the Register Server Wizard.

    Creating Queries

    You can run queries by:

    • Using tables and columns you specify.
    • Creating result sets from a stored procedure.
    • Selecting data using Transact-SQL statements.

    The Web Assistant Wizard requires that each job be named, and a default name is supplied. For jobs that will run at a later time or for jobs that run on a continuous basis, choose a name that will help you remember the focus of this query.

  • March 29, 2004 at 9:29 pm

    #501003

    I am not able to get the Web Assistant Wizard option when i click on Wizards Tool button.

    It only comes if i loging to server in Enterprise Manager as sa.

    But if i login as a normal DB user who is dbo on some of the databases, this option doesnt come in the Wizards tool box.

    If you knw whats the appropriate security privileges needs to be given, please let me know.

    Regards

    Jay

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

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