Re: The application requires more database privileges than you have currently been granted.

"Gustaf" <gustafl_at_algonet.se> schreef in bericht
news:wNadnTsxNYYf3EzanZ2dnUVZ_gqdnZ2d_at_giganews.com...
> Shakespeare wrote:>>>> The Oracle version is 10.2.0.1. I don't know what 'application' means >>> here. Is it yet another name for 'user', 'account' and 'schema'? So far, >>> I'm doing everything in Enterprise Manager.>>> Do I understand correctly that what you actually are saying is that the >> newly created users cannot login to ENTERPRISE MANAGER?>> That's right. And now I understand that Enterprise Manager (EM) is the > 'application', and if I attempt to access the DB from SQL Plus, other > rules apply. I'm trying to figure out what the minimum privileges are to > log in with EM, but I begin to see how pointless it is. EM is not the way > the average user connect anyway, is it?>> What I really want is to create a user with full control over a schema. > Adding and removing tables, and importing data into those tables. I wish > there was a SCHEMA_ADMIN role, but I can't find anything like it. And it's > hard to figure out exactly which of the hundreds of privileges I need to > put together such a role.>> Gustaf

Ah, that puts some light on the issue. EM is indeed not the tool for the
average user. The privileges David posted should do.