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


"Gustaf" <gustafl@xxxxxxxxxx> schreef in bericht
news:wNadnTsxNYYf3EzanZ2dnUVZ_gqdnZ2d@xxxxxxxxxxxxxxx
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.

Shakespeare


.

Relevant Pages

  • Re: Getting a list of Stored Procedures
    ... >>persmissions in Enterprise manager and it brings up the ... >>you can tick or x privileges for users. ...
    (microsoft.public.sqlserver.programming)
  • Locked out of Enterprise Manager
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... Enterprise Manager lost connection and would no longer connect.. ...
    (microsoft.public.sqlserver.security)
  • Re: Storing/saving sessions on SQL Server
    ... If you dont have enterprise manager, download SQL ... "SQL Server does not exist or access denied. ... "Cannot open database requested in login 'ASPState'. ...
    (microsoft.public.dotnet.framework)
  • Re: Change in sa password, scheduled jobs failing
    ... The sa login and password are likely referenced in the ... login and you right click on the package, select Schedule ... this will create an encrypted DTSRun command in the ... currently be logged in as through Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)
  • Re: Change in sa password, scheduled jobs failing
    ... The sa login and password are likely referenced in the ... login and you right click on the package, select Schedule ... this will create an encrypted DTSRun command in the ... currently be logged in as through Enterprise Manager. ...
    (microsoft.public.sqlserver.security)