Transfer ownership idea (concept + SQL)

SQL Hard 3 views
Back to Questions
Previous Least privilege for stored procedures Hard P Next Grant column-level access (hard) Hard N

Problem Description

If a user owns objects and you want to drop the user, what should you do first? Write a safe sequence in SQL terms.

Input Format

SQL script

Output Format

Statements

Sample Test Case

Input:
Owned objects exist
Output:
Ownership transferred

Constraints

DB-specific; show general idea
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next