Typically in a database you have many users.
The owner shcema that owns the objects, usually decides the privileges given to other users on the objects it owns.
Lets call the schema owner "OWNER" and suppose we have another user in the database called "READER".
For the user "READER" to be able to view the data in a table owned by "OWNER", the owner has to grant the reader select priviliges.
Similarly the owner can grant insert,update, delete, etc privileges on a certain object to other users in the database.
To take away a certain privilege from a user
Unless a user has select privileges on an object owned by another schema, or that object has a synonym created, the user will not be able to access that object.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 17 weeks ago
2 years 22 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 24 weeks ago
2 years 24 weeks ago
2 years 26 weeks ago
2 years 28 weeks ago
2 years 31 weeks ago
2 years 37 weeks ago