Dear forum,
I have Oracle 9i/10g2R and sun solaris server I don't realy sure wheter it's sun solaris 8, 9 or 10.
Here is the background:
OS : SunOS 8/9/10
Oracle engine : 9i / 10g2R
--> located in server SunOS
Remote Komputer : Windows XP, I use SSH to remote to the server
User : DBA1, ADMINISTRATOR or SYS
My problem is, I need to granted DBA1 the roles for DBA, so he has full access to the database. He remote to the database using listener.ora (I mean remote to the database not to the server).
In the other hand, I can remote to the server and run the database from the server that I already remote.
I need to grant DBA1 to be able to create tablespace and datafile (I have stored procedure that automaticaly do this).
############## My Problem I put bellow ###################
What I want to know is how can I only allow DBA1 to create and alter tablespace and datafile only from stored procedure or he remote to the server. So if DBA1 remote to the database using listener.ora not remote to the server using ssh or using stored procedure, he can't create or alter tablespace and datafile.
###################################################
Thanks in advance for the help
Regards,
Aditya Purwanto
Edit/Delete Message