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".