Discuss SQL query to grant permission in the Oracle Development forum on Dev Shed. SQL query to grant permission Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.
Time spent in forums: 41 m 47 sec
Reputation Power: 0
Originally Posted by debasisdas
What kind of users you are talking about ?
Normal User whose account is blocked for 15 days
any scenario you can consider
Example -:College database
Teacher has right to upddate and delete marks and many other right like admin
student can only log in and can see results and raise objection.
Time spent in forums: 1 Week 6 Days 2 h 37 m
Reputation Power: 382
Can you elaborate in simple words?
I will try
However, it looks as if you could benefit from reading some of the Oracle documentation on users and grants.
(all subject to being corrected as I am going from memory)
Any user who creates an object (TABLE, PROCEDURE, VIEW, SEQUENCE etc.) is the
only user who can access that object unless that user GRANTS permission to other users by name or to PUBLIC.
Permissions can also be granular. e.g. You could grant someone SELECT and UPDATE permission on a table but not INSERT and DELETE.
As I understand it, there are also certain super users like DBA and system manager who have rights over everything whether they created it or not.
There is a lot more to the whole subject.
Lots of rules I have not mentioned and things I have mentioned that probably have all sorts of additional variants.
For your purposes it is probably sufficient to know that you have to grant permission of some sort on objects you create for any other regular user to be able to access them.