2006-09-24 19:53:06 · 5 answers · asked by p o 1 in Computers & Internet ➔ Programming & Design
In Oracle, a user is allowed to view/ access/use an object if and only if he / she has the right to do so. The rights or permissions assigned to user(s) to use some or all of Pracle resources on server are known as privileges.
The are of two types.
1. System Privileges: grant the ability to create , modify and remove the database objects that store data for application such as table.
2. Object Priviliegs: to work / use / access already created database objects. Rights are select, insert,update,delete,alter,index,references,exeute.
CHECK YOUR SYSTEM AND OBJECT PRIVILEGES.
2006-09-24 20:07:45 · answer #1 · answered by shivani k 1 · 0⤊ 0⤋
Well shivani_k is correct. What she has writen is true for most standard RDBMS. For oracle go to sys account or some account with DBA privilages. Then give grant command the syntax for which is as follows.
grant all
on
to
U really have given too little detail. With that it's not possible to give more specific answer.
2006-09-25 10:32:57 · answer #2 · answered by binaryFusion 5 · 0⤊ 0⤋
The information in the data base may be protected. Look under format, and see if protectin is clicked. If so, just click it off and you should be able to type what you want.
2006-09-24 19:55:47 · answer #3 · answered by ANGELA A 2 · 0⤊ 0⤋
where u have created table ? I mean which programming package. It is easy for me to answer if u answer me.
2006-09-25 00:05:35 · answer #4 · answered by ravi 1 · 0⤊ 0⤋
You have no permission to do this. Ask Your DB-supporter!
2006-09-26 05:17:02 · answer #5 · answered by Anonymous · 0⤊ 0⤋