ThatJeffSmith

Tag: user

30 SQL Developer Tips in 30 Days, Day 24: Hiding Schemas That Don’t Own Anything

Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply […]

Similar Posts by Subject Areas: , , , ,

Managing User & Role Security with Oracle SQL Developer

With the advent of SQL Developer v3.0, users have had access to some powerful database administration features. Version 3.1 introduced more powerful features such as an interface to Data Pump and RMAN. Today I want to talk about some very simple but frequently ran tasks that SQL Developer can assist with, like: identifying privs granted […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , ,