Post reply

problem with creating a view

  • January 31, 2005 at 3:06 pm

    #87574

    Hi,

    I am running sql 2000 sp3 on a windows 2003 server.

    What I am tring to do is create a view for a user.   Here is the TSQL

    statement and the error.

    Create View [iv\markw].vwItemBatchUsers as Select Batch_Name from Batch_Item

    where batch_name = 'markw'

    Server: Msg 2760, Level 16, State 1, Procedure vwItemBatchUsers, Line 1

    Specified owner name 'iv\markw' either does not exist or you do not have

    permission to use it.

    I can make a view for this same user on a different database just find.  I

    also had the user run the select statement and it worked.

    Any ideas?

    Thanks

    Mark

  • January 31, 2005 at 3:49 pm

    #539825

    If the create view works on one database, but not the other, I would first check to make sure that user iv\markw has been added onto the current db.



    David W. Clary
    MCSD
    Data Miner 49er
    Sr. Database Administrator, Ceiva Logic

  • February 1, 2005 at 1:22 am

    #539870

    Also check the user roles and available permissions

  • February 1, 2005 at 11:30 am

    #540001

    I think we are getting closer.  When I ran SELECT USER_ID('iv\markw') on PO database it return NULL.
    One thing I did not tell you is I'm using NT AUTHENTICATION. 
    So iv\markw is in the IV\READWRITE group.
    The READWRITE group show up in the list when I ran sp_helplogins.
    If I run SELECT USER_ID('iv\markw') on HIST database it return 89.
    These two database are on the same server and the server is a domain controller.
     
    Any other ideas?

  • February 1, 2005 at 12:15 pm

    #540010

    Does that user have permissions to create a view in the database?


    Shamless self promotion - read my blog http://sirsql.net

Viewing 5 posts - 1 through 4 (of 4 total)

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