Archives of the TeradataForum
Message Posted: Tue, 27 Nov 2012 @ 15:43:07 GMT
| Subj: || || Re: Restriction on Space Movement |
| From: || || Anomy Anom |
< -- Anonymously Posted: Tuesday, November 27, 2012 10:15 -- >
Don't grant CREATE/DROP DATABASE directly to this group of users. Create a Stored Procedure, using a privileged ID, which uses dynamic SQL to
do the CREATE DB, GIVE, DROP DB that accomplishes the "move space" operation, accepting the target DB and size as parameters. Then grant the users
permission to execute the SP.