Help - Search - Members - Calendar
Full Version: Public Grants
Oracle DBA Forums > Oracle > Oracle Forum
Nancy_FA
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
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
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.
Invision Power Board © 2001-2014 Invision Power Services, Inc.