Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    Amsterdam
    Posts
    18

    Unanswered: Owner of database

    I've written code that allows a user to create a table according to their specifications. However, when I as another user tries to open the table, I get all sorts of errors. The only reason I can think that this happens is because I dont have sufficient permission/s to access that table. Is this correct, and if so, how do I get around this problem ?

    Many thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You should GRANT permissions for other user to access the table.
    Refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Owner of database

    The table owner could also be causing you some greif. In other words if you create 'tbl_one' with 'user_one' and then try and access the table with 'user_two' you may need to explictly identify the tables owner. In other words 'select * from user_one.tbl_one' .
    Of course just as Satya mentioned the user would need select permissions on this table (user_one.tbl_one)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •