|
-
Assume I have a user "A". User "A" has tables and procedures in his schema. Now assume I have user "B". User "B" has been granted access to a stored procedure in user "A"'s schema. The stored procedure creates a table. I know that the procedure will create a table in user "A" 's schema if user "A" executes it, but what happens if user "B" executes it? In whose schema does the table get created? Assume the procedure does not have any schema qualifier such as "create table a.newtable ...".
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|