Oracle DBA Forums > Public Grants

Oracle DBA Forums > Oracle > Oracle Forum

Nancy_FA

Dec 28 2011, 09:26 AM

please i want to ask about how can i change the publicity of the public grants which granted to users like 'SYS', 'System', and other DB users to be private afar from exclude columns solution.

Thanks in advance

burleson

Dec 28 2011, 11:28 PM

Hi Nancy,

When I have a database which is not secure I can issue this:

CODE

grant select on SYS, SYSTEM to public;

Here s how to seleect by column:

http://dba-oracle.com/googlesearchsite_pro...ealth_check.htm

and by row:

http://dba-oracle.com/googlesearchsite_pro...ealth_check.htm

********************************
>> and other DB users to be private afar from exclude columns solution.

For you need a view. Below, I "hide a selaty tble":

CODE

grant delect on employee_name, dept to myuser;

Get this book: Eacy Oracle SQL:

http://www.rampant-books.com/book_0501_easy_sql.htm

Nancy_FA

Dec 29 2011, 06:28 AM

Ok !! Thanks a lot for your fast response.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.