I am trying to delete a user created ID from the database. If I use the following command:
drop user sfcs;
the cascade parameter is required. Which command can I run to identify objects owned by this user?
select * from dba_objects where owner = 'SFCS';
Dig Deeper on Oracle database security
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.