Privileges On Procedures/Functions/Packages

Aakash

hi,

can anyone tell me which tables/views to refer to find
the "execute" privileges given on objects like
procdure/functions/packages ?

its urgent .... any help will be appreciated.

regards,
aakash

Jul 19 '05 #1

Subscribe Post Reply

20391

mcstock

strangely, it's DBA_TAB_PRIVS (and related views like ALL_TAB_PRIVS,
ALL_TAB_PRIVS_RECD, etc.)

also, there's no object_type column in this very old view, so you need to
join with DBA_OBJECTS (or a related view) if you are looking for privs on a
specified object type

another anomaly in the data dictionary: you'll find VIEW column definitions
in DBA_TAB_COLUMNS
--
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048

"Aakash" <da*****@yahoo.com> wrote in message
news:83**************************@posting.google.c om...

hi,

can anyone tell me which tables/views to refer to find
the "execute" privileges given on objects like
procdure/functions/packages ?

its urgent .... any help will be appreciated.

regards,
aakash

Jul 19 '05 #2

Aakash

thanks for the help mark.
its really strange that DBA_TAB_PRIVS shud have info abt
objects like procs/funcs etc. i was at my wits end
trying to figure out where possibly they cud be.
thanks again
"mcstock" <mc******@xenquery.com> wrote in message news:<7Y********************@comcast.com>...

strangely, it's DBA_TAB_PRIVS (and related views like ALL_TAB_PRIVS,
ALL_TAB_PRIVS_RECD, etc.)

also, there's no object_type column in this very old view, so you need to
join with DBA_OBJECTS (or a related view) if you are looking for privs on a
specified object type

another anomaly in the data dictionary: you'll find VIEW column definitions
in DBA_TAB_COLUMNS
--
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048

"Aakash" <da*****@yahoo.com> wrote in message
news:83**************************@posting.google.c om...
hi,

can anyone tell me which tables/views to refer to find
the "execute" privileges given on objects like
procdure/functions/packages ?

its urgent .... any help will be appreciated.

regards,
aakash

Jul 19 '05 #3

by: JingleBEV | last post by:

Hi all, I am trying not to use global variable to maintain data consistency. Some procedures and functions will require to pass the recordset object for processing and functions may also return...

Visual Basic 4 / 5 / 6

Granting the privileges of existing objects within a schema to a new role

by: Ted | last post by:

How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without having to issue a grant statement for each object...

Oracle Database

Nested Stored Procedures and Packages

by: Anthony Robinson | last post by:

Have been encountering an odd issue. Every now and again, certain packages of stored procedures just become invalid. I'm aware that dropping or altering an underlying table would render a package...

DB2 Database

privileges on packages - db2 8.2.2

by: virgilio | last post by:

Hi all, "Administrator Guide Implementation" DB2 8.2, chapter 7, section "Indirect privileges through a package" states: (highlight >>>>!!!<<<<) "Privileges granted to individuals binding the...

DB2 Database

How to replace Procedures/Functions?

by: tomtailor | last post by:

Hello! Since I changed to DB2 I have replaced my stored Procedures or Functions by DROP and CREATE. But now the applications logic is complex enough that I have to look for a easier way. I do...

DB2 Database

Procedures/Functions

by: Anil Gupte | last post by:

Hopefully this list is newbie-friendly. I have a conceptual questions. I am learning VB and came across the description in a book I am using that describes procedures vs. functions. I understand...

Visual Basic .NET

restrict privileges

by: Frank Swarbrick | last post by:

I feel like an idiot for asking this, but neither I nor my DBA can figure this out. How do you create a database object that does not implicitly allow access by any defined user? For instance,...

DB2 Database

Privileges On Procedures/Functions/Packages

by: Aakash | last post by:

hi, can anyone tell me which tables/views to refer to find the "execute" privileges given on objects like procdure/functions/packages ? its urgent .... any help will be appreciated. ...

Oracle Database

privileges on functions

by: uwcssa | last post by:

I created one function and wish to assign it to some users. however, even though "grant execute on function" succceeded, that user can still not use it. i am wondering if functions do not have...

DB2 Database

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Privileges On Procedures/Functions/Packages

Similar topics