Select * from dba_sys_privs where grantee='R1';
Select * from dba_tab_privs where grantee='R1';
Select * from dba_tab_privs where owner='schema' and
table_name='table_name';
-Original Message-
Sent: Tuesday, September 09, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Hi List
:
@fcg.comSubject: RE: Privileges associated with
Role
Sent by:
ml-errors
I should have read your question more closely. The grants script that I
provided will also work with a role instead of a userid.
To get all the privileges granted on a table select * from dba_tab_privs
where table_name = 'TABLE_YOU'RE_INTERESTED_IN';
dba_sys_privs
role_sys_privs
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 21:44
Hi List
How to look for all the privileges associated with
particular Role(for example R1)?
--
Please see the official ORACLE-L
Hi
I wrote script some time back that you use to find all privileges
granted to a user or role, system, object and role. It does this
hierarchically so that it shows privs granted to roles granted to roles
etc. It is available from http://www.petefinnigan.com/tools.htm its the
first script
Title: RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under schema A and grant execute on those to B and C.
Sorry ... that's the only way to go ...
Raj
Rajendra dot
: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Privileges needed for
truncate
[EMAIL PROTECTED
Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Privileges needed for truncate
To truncate you need delete privileges. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Tuesday, September 24, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Privileges needed for truncate
delete wasn't enough for me. had to grant 'drop any table'.
From the Oracle8i SQL
-
Sent: Tuesday, September 24, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Privileges needed for truncate
delete wasn't enough for me. had to grant 'drop any table'.
From the Oracle8i SQL Reference
Release 3 (8.1.7) manal:
To truncate a table or cluster
24, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Privileges needed for truncate
delete wasn't enough for me. had to grant 'drop any table'.
From the Oracle8i SQL Reference
Release 3 (8.1.7) manal:
To truncate a table or cluster, the table or cluster must
Title: RE: Privileges needed for truncate
Alter any table
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can
Unfortunately drop any table.
-Original Message-
Sent: Thursday, September 19, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Hi
I need to create a user/role that among other stuff must be able to
truncate a table. I can't figure out which privileges are needed (DBA is a
bit
DROP ANY TABLE include the privilege TRUNCATE. But is not so secure.
An ohher way is create a procedure to do the truncate base on user_table
wich who is the owner of the tables.
-Message d'origine-
De: Jack van Zanen [mailto:[EMAIL PROTECTED]]
Date: jeudi
Jack,
It used to be DELETE ANY TABLE. I'm not sure if that has changed in recent
versions. Long ago, I setup the following procedure to allow a specific table to be
truncated, without out the DELETE ANY TABLE privilege. It must be owned by the owner
of the table. I haven't dealt with
: jeudi 19 septembre 2002 17:24
À: Multiple recipients of list ORACLE-L
Objet: RE: Privileges needed for truncate
Unfortunately drop any table.
-Original Message-
Sent: Thursday, September 19, 2002 10:24 AM
To: Multiple recipients of list
To truncate you need delete privileges. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 10:23 AM
Hi
I need to create a user/role that among other stuff must be able to
truncate a table. I can't figure out which
zhu chao,
Thanks for checking this out. I tried it again this morning and it worked
like your example. At first I thought there might be a difference when
creating a view on all rows (*) versus creating the view on a subset (x, y,
z) but under both conditions a view was created successfully.
Hand, Michael T,
hi, what you tested is not the normal behavior of oracle, neither the document
said like that nor in my database behavior like that.Maybe something is wrong with
your database:)
Look:
SQL conn internal
Connected.
SQL create user t identified by t;
User
This happened to us a few weeks ago, select worked over db_link and desc
didn't. Think it's a bug, not a privs problem.
Adams, Matthew (GEA, MABG, 088130) wrote:
All of a sudden this is not making sense to me.
Oracle 8.1.7.3 on HP-UX 11i
I have a public db link (link1)
I have a
The problem wasn't consistent either, desc worked for some objects over
db_link but not for others. And didn't see anything different about how
the privs were granted for those objects.
Suzy Vordos wrote:
This happened to us a few weeks ago, select worked over db_link and desc
didn't.
Title: privileges and synonyms and dblinks
Matt,
We have run in to this issue.
There are some bugs related to this.
Pl review docs on Metalink # 159051.1, #
144114.1.
-
Kirti
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent:
recipients of list ORACLE-LSubject:
RE: privileges and synonyms and dblinks
Matt,
We have run in to this issue.
There are some bugs related to this.
Pl review docs on Metalink # 159051.1, #
144114.1.
-
Kirti
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL
Hi,
Can someone please explain what is happening in this
case.
I created link lnkAB from instA to instB, it is a
private db link. with username and password in the
link.
And then I created a synonym syntableX
(not public) on the [EMAIL PROTECTED]
Now I tried desc syntableX at my instanceA,
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 19, 2001 15:05
Hi,
Can anyone point me in the direction of a list of privileges (version
8.1.7)
and their meanings. Obviously most are self explanatory but there are a
few
try:
Dave,
By relevant section I assume you mean under GRANT in Oracle8i SQL
Reference. Table 11-1 System Privileges is self-explanatory while
tables 11-3 and 11-4 cover object privileges.
For a full explanation of what any particular privilege implies, you'll have
to dig into the docs and find
It's in DBA_TAB_PRIVS.
Dennis
SUNILSHIVAPPA wrote:
hi,
HOW to find out the whether a particular user has a execute
permission on package or not.
Regards,
sunil s.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
INET: [EMAIL
Check out DBA_TAB_PRIVS and look for the EXECUTE privilege.
Jon Walthour
-Original Message-
Sent: Monday, October 01, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L
hi,
HOW to find out the whether a particular user has a execute
permission on package or not.
Regards,
Title: RE: privileges on packages
USER_TAB_PRIVS.
Here is an example:
[EMAIL PROTECTED] create or replace package my_pack is
2 type abc_t is table of number index by binary_integer;
3 p_abc abc_t;
4 p_un varchar2(20);
5 end my_pack;
6 /
Package created.
[EMAIL PROTECTED] show
this is documented, standard behavior
you cannot use privileges granted via a role to write a stored procedure.
Grant all on the table to user1 directly from owner1 and the procedure will
run.
Or, probably better, would be to develop the procedure as owner1 and grant
execute on it to
You cannot use privileges granted through a role to create packages and procedures.
They have to be directly granted to the user creating the packages and procedures.
-Original Message-
Sent: Tuesday, August 07, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
I have granted
Laura,
You need to do the grants directly to the user that is creating the
procedure/package. Major pain. I didn't believe the developers when
they told me that, but after adequate testing I realized they were right.
Roles are still good for managing security of the rest of the db users,
32 matches
Mail list logo