Explanation:
The user who creates an object becomes its owner, regardless of who owns the parent object.
Ultimate access to all questions.
No comments yet.
Kevin owns the schema 'sales'. Steve wants to create a new table named 'regional_sales' within the 'sales' schema. Kevin grants Steve the permission to create tables. After Steve creates the 'regional_sales' table in the 'sales' schema, who owns the 'regional_sales' table?
A
Kevin, as the owner of the 'sales' schema, automatically owns all tables within it.
B
Steve becomes the owner of the table since he created it.
C
Ownership is by default assigned to DBO.
D
Ownership is by default assigned to DEFAULT_OWNER.
E
Both Kevin and Steve share ownership of the table.