Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    15

    Unanswered: Table Owner problem

    Hi,

    I got a database with a group of poeple working on it. Some users create temptables
    through reports that they run and thus are the owners. I want all reports that are created in this way(temp tables) to be owned by spesific user and not by the different users.

    Reason: All members in group can for instance view tables created by Joe thus all tables created should be owned by Joe. I don't want to put code into each table created like GRANT ALL or something.

    Is it possible to create on the database a global variable thus for each table in the future created would be owned by "Joe".

    Thanks in advance....!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which database? you posted the same message in the mysql and postgresql forums, and we're gonna delete one of them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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