| how to give user right to take export of his own schema? [message #145903] |
Mon, 07 November 2005 10:44  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I want to give right to scott user so that he can take export of his own schema or export of his own object... is there is any way he can do expot ....
i need query for this ,,,
Note:- i dont want to give him sysdba rights.
thanks & regards
Friendly sunilkumar
|
|
|
|
|
|
| Re: how to give user right to take export of his own schema? [message #145907 is a reply to message #145905] |
Mon, 07 November 2005 11:09  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Thanks for your reply maheshji ....but
can u tell me how do I stop scott (i.e. database users) taking export of his own schema
which privillege i have to revoke from scott so that he cannot take export..?
One thing more i want to know ,,, if scott (i.e. user of database) dont have any right to connect the o/s of database server other than sqlplus, then how scott will take export of his own schema....Is it possible for scott to take export of his schema in this senario?
Friendly sunilkumar
|
|
|
|
|
|
| Re: how to give user right to take export of his own schema? [message #146659 is a reply to message #145913] |
Fri, 11 November 2005 17:43 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Earlier i was managing DB of hosting company which provide web space & database (i.e. Oracle) space to the web developer all web developer were my user. They were connecting to the database remotly but not able to access o/s file of server on which DB was present coz they dont have right to access that server other than SQLPLS .
Always they were asking me for the dmp of there schema and that i have to do create for them... now if they were able to create dmp then y i was doing all those stuff for them ...
Still not able to understand y they are not able to take export of there own schema
Regards
Always Friend Sunilkumar.
[Updated on: Fri, 11 November 2005 17:44] Report message to a moderator |
|
|
|
| Re: how to give user right to take export of his own schema? [message #146809 is a reply to message #146659] |
Mon, 14 November 2005 00:51 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
They were not able to use export command as you had restricted access to them & they were able to use sqlplus.exe only for accessing database.
Now they could have done that had they known this.
On wondows:
In SQL prompt they could have invoked the exp command by typing
host exp
On unix:
!exp
I think that makes the issue clear.
--Girish
|
|
|
|
|
|
| Re: how to give user right to take export of his own schema? [message #146876 is a reply to message #146659] |
Mon, 14 November 2005 06:45 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>hey were connecting to the database remotly
How exactly?
If they are invoking sql*plus sessions directly in the server,
their exported dump will reside in the server.
If they are invoking sql*plus sessions from a client,then the file is in their client.
>>they dont have right to access that server other than SQLPLS .
Are you serious?
Developing applications / writing big time code in pure sql*plus is a pain. Any developer needs some TOAD or any GUI based tools/IDE.
There is nothing wrong with sql*plus. It is just not very friendly with programmers/coding practises. Sql*Plus is the best used for short scripting ( Like i do) and is very handy.
>>Still not able to understand y they are not able to take export of there own schema
girish responded for this.
[Updated on: Mon, 14 November 2005 06:46] Report message to a moderator |
|
|
|
| Re: how to give user right to take export of his own schema? [message #147465 is a reply to message #146876] |
Thu, 17 November 2005 13:23 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Sorry mahesh and every one ,,, my ideas are clear now ,,, i was giving export dmp to the client coz the network connection (internet speed) was slow for clinet who where connecting to the remote server were database was residing ...
yea user have right to take export of his own schema by starting export utility from his end.
Thank for giving time to my question
Regards
Always Friendly Sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
