Home » SQL & PL/SQL » SQL & PL/SQL » user created with default automatic privilege (oracle 9i )
user created with default automatic privilege [message #419428] Sat, 22 August 2009 03:18 Go to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i have created a user in oracle 9.2.0.1.0 on window xp

create user xxx identified by xxx

by default the user shouldn't have any privileges ,but the user is able to connect to database ,and also can create user ,table,and tablespace


when i run the view select * from session_privs ,it shows 140 privileges in that

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
ALTER SYSTEM
AUDIT SYSTEM
CREATE SESSION
ALTER SESSION
RESTRICTED SESSION
CREATE TABLESPACE
ALTER TABLESPACE
MANAGE TABLESPACE
DROP TABLESPACE
UNLIMITED TABLESPACE
CREATE USER

PRIVILEGE
----------------------------------------
BECOME USER
ALTER USER
DROP USER
CREATE ROLLBACK SEGMENT
ALTER ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT
CREATE TABLE
CREATE ANY TABLE
ALTER ANY TABLE
BACKUP ANY TABLE
DROP ANY TABLE

PRIVILEGE
----------------------------------------
LOCK ANY TABLE
COMMENT ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE CLUSTER
CREATE ANY CLUSTER
ALTER ANY CLUSTER
DROP ANY CLUSTER
CREATE RULE

PRIVILEGE
----------------------------------------
CREATE ANY RULE
ALTER ANY RULE
DROP ANY RULE
EXECUTE ANY RULE
CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX
CREATE SYNONYM
CREATE ANY SYNONYM
DROP ANY SYNONYM
CREATE PUBLIC SYNONYM

PRIVILEGE
----------------------------------------
DROP PUBLIC SYNONYM
CREATE VIEW
CREATE ANY VIEW
DROP ANY VIEW
CREATE SEQUENCE
CREATE ANY SEQUENCE
ALTER ANY SEQUENCE
DROP ANY SEQUENCE
SELECT ANY SEQUENCE
CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK

PRIVILEGE
----------------------------------------
DROP PUBLIC DATABASE LINK
CREATE ROLE
DROP ANY ROLE
GRANT ANY ROLE
ALTER ANY ROLE
AUDIT ANY
ALTER DATABASE
FORCE TRANSACTION
FORCE ANY TRANSACTION
CREATE PROCEDURE
CREATE ANY PROCEDURE

PRIVILEGE
----------------------------------------
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
CREATE TRIGGER
CREATE ANY TRIGGER
ALTER ANY TRIGGER
DROP ANY TRIGGER
CREATE PROFILE
ALTER PROFILE
DROP PROFILE
ALTER RESOURCE COST

PRIVILEGE
----------------------------------------
ANALYZE ANY
GRANT ANY PRIVILEGE
CREATE SNAPSHOT
CREATE ANY SNAPSHOT
ALTER ANY SNAPSHOT
DROP ANY SNAPSHOT
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE TYPE
CREATE ANY TYPE
ALTER ANY TYPE

PRIVILEGE
----------------------------------------
DROP ANY TYPE
EXECUTE ANY TYPE
UNDER ANY TYPE
CREATE LIBRARY
CREATE ANY LIBRARY
ALTER ANY LIBRARY
DROP ANY LIBRARY
EXECUTE ANY LIBRARY
CREATE OPERATOR
CREATE ANY OPERATOR
DROP ANY OPERATOR

PRIVILEGE
----------------------------------------
EXECUTE ANY OPERATOR
CREATE INDEXTYPE
CREATE ANY INDEXTYPE
ALTER ANY INDEXTYPE
DROP ANY INDEXTYPE
UNDER ANY VIEW
QUERY REWRITE
GLOBAL QUERY REWRITE
EXECUTE ANY INDEXTYPE
UNDER ANY TABLE
CREATE DIMENSION

PRIVILEGE
----------------------------------------
CREATE ANY DIMENSION
ALTER ANY DIMENSION
DROP ANY DIMENSION
MANAGE ANY QUEUE
ENQUEUE ANY QUEUE
DEQUEUE ANY QUEUE
CREATE ANY CONTEXT
DROP ANY CONTEXT
CREATE ANY OUTLINE
ALTER ANY OUTLINE
DROP ANY OUTLINE

PRIVILEGE
----------------------------------------
ADMINISTER RESOURCE MANAGER
ADMINISTER DATABASE TRIGGER
ON COMMIT REFRESH
RESUMABLE
SELECT ANY DICTIONARY
DEBUG CONNECT SESSION
DEBUG ANY PROCEDURE
FLASHBACK ANY TABLE
GRANT ANY OBJECT PRIVILEGE
CREATE EVALUATION CONTEXT
CREATE ANY EVALUATION CONTEXT

PRIVILEGE
----------------------------------------
ALTER ANY EVALUATION CONTEXT
DROP ANY EVALUATION CONTEXT
EXECUTE ANY EVALUATION CONTEXT
CREATE RULE SET
CREATE ANY RULE SET
ALTER ANY RULE SET
DROP ANY RULE SET
EXECUTE ANY RULE SET

140 rows selected.

i try to revoke that privileges but it throws a error
SQL> revoke create user from xxx;
revoke create user from xxx
*
ERROR at line 1:
ORA-01952: system privileges not granted to 'xxx'


how can a user can get 140 default privileges at the time of creation ,please help me out of this mess Sad

[Updated on: Sat, 22 August 2009 03:31]

Report message to a moderator

Re: user created with default automatic privilege [message #419430 is a reply to message #419428] Sat, 22 August 2009 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet this account has DBA role.
Check dba_role_privs or session_roles.

Regards
Michel
Re: user created with default automatic privilege [message #419433 is a reply to message #419430] Sat, 22 August 2009 04:00 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i have run the query

select * from session_roles;

ROLE
------------------------------
DBA
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
WM_ADMIN_ROLE
JAVA_ADMIN
JAVA_DEPLOY

ROLE
------------------------------
XDBADMIN
OLAP_DBA

13 rows selected.


but how this role is been granted at the time of user creation
and i,m unable to revoke this role from the user

SQL> CONN / AS SYSDBA
SQL> CONNECTED.

SQL> REVOKE DBA FROM XXX;
REVOKE DBA FROM XXX
*
ERROR at line 1:
ORA-01951: ROLE 'DBA' not granted to 'XXX'

Re: user created with default automatic privilege [message #419450 is a reply to message #419428] Sat, 22 August 2009 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>i have created a user in oracle 9.2.0.1.0 on window xp
9i is obsoleted & unsupported

>create user xxx identified by xxx
>by default the user shouldn't have any privileges ,but the user is able to connect to database ,and also can create user ,table,and tablespace

Yes, not default or expected behaviour

Provide proof using sqlplus
SQL> SET TIME ON

use CUT & PASTE showing whole & complete session

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: user created with default automatic privilege [message #419454 is a reply to message #419433] Sat, 22 August 2009 09:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What you posted is not possible.
Drop the user and, as BlackSwan said, use SQL*Plus and copy and paste all what you do and get then we can set and reproduce it.

Regards
Michel
Re: user created with default automatic privilege [message #419460 is a reply to message #419433] Sat, 22 August 2009 14:07 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Show us that you actually logged in as the new user..
Re: user created with default automatic privilege [message #419494 is a reply to message #419460] Sun, 23 August 2009 05:16 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> set time on
15:41:15 SQL> show user
USER is "SYS"
15:41:18 SQL> create user xxx identified by xxx_1;

User created.

15:41:34 SQL> conn xxx/xxx_1
Connected.
15:41:52 SQL> create table xxx(name char(12));

Table created.

15:42:14 SQL> desc xxx;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME CHAR(12)

15:42:19 SQL> select * from session_roles;

ROLE
------------------------------
DBA
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
WM_ADMIN_ROLE
JAVA_ADMIN
JAVA_DEPLOY

ROLE
------------------------------
XDBADMIN
OLAP_DBA

13 rows selected.

15:42:28 SQL> conn / as sysdba
Connected.
15:42:36 SQL> revoke dba from xxx;
revoke dba from xxx
*
ERROR at line 1:
ORA-01951: ROLE 'DBA' not granted to 'XXX'


15:42:52 SQL> revoke SELECT_CATALOG_ROLE from xxx;
revoke SELECT_CATALOG_ROLE from xxx
*
ERROR at line 1:
ORA-01951: ROLE 'SELECT_CATALOG_ROLE' not granted to 'XXX'


15:43:04 SQL>

as per the guideline i have posted the problem again
Re: user created with default automatic privilege [message #419505 is a reply to message #419494] Sun, 23 August 2009 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>SQL> set time on
>15:41:15 SQL> show user
>USER is "SYS"
>15:41:18 SQL> create user xxx identified by xxx_1;
>
>User created.
>
>15:41:34 SQL> conn xxx/xxx_1
>Connected.
>15:41:52 SQL> create table xxx(name char(12));
Things are really, really non-standard.
On default/standard system user XXX could NOT connect because no privilege to do
so was granted.
Some sort of trigger MUST exist to issue GRANT to allow subsequent actions.
Re: user created with default automatic privilege [message #419506 is a reply to message #419505] Sun, 23 August 2009 11:31 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
so what to do,is there any chance of database been corrupted or infected with a virus
Re: user created with default automatic privilege [message #419507 is a reply to message #419506] Sun, 23 August 2009 11:38 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Some sort of trigger MUST exist to issue GRANT to allow subsequent actions.
If you want to change results, you need to find & either disable or drop trigger that is issuing GRANT when CREATE USER is done.
Re: user created with default automatic privilege [message #419508 is a reply to message #419507] Sun, 23 August 2009 12:11 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
but how to do this ,where i can find that trigger which is doing this commotion

i have used the view user_triggers but unable to find any relevant information

[Updated on: Sun, 23 August 2009 12:20]

Report message to a moderator

Re: user created with default automatic privilege [message #419509 is a reply to message #419428] Sun, 23 August 2009 12:30 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> desc dba_triggers
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER						    VARCHAR2(30)
 TRIGGER_NAME					    VARCHAR2(30)
 TRIGGER_TYPE					    VARCHAR2(16)
 TRIGGERING_EVENT				    VARCHAR2(227)
 TABLE_OWNER					    VARCHAR2(30)
 BASE_OBJECT_TYPE				    VARCHAR2(16)
 TABLE_NAME					    VARCHAR2(30)
 COLUMN_NAME					    VARCHAR2(4000)
 REFERENCING_NAMES				    VARCHAR2(128)
 WHEN_CLAUSE					    VARCHAR2(4000)
 STATUS 					    VARCHAR2(8)
 DESCRIPTION					    VARCHAR2(4000)
 ACTION_TYPE					    VARCHAR2(11)
 TRIGGER_BODY					    LONG
Re: user created with default automatic privilege [message #419510 is a reply to message #419509] Sun, 23 August 2009 13:10 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i have used this view but unable to find any triggers related to create user event ,thanks anyway
Re: user created with default automatic privilege [message #419511 is a reply to message #419428] Sun, 23 August 2009 13:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
select trigger_name from dba_triggers where owner = 'SYS' and triggering_event like 'CREATE%';
Re: user created with default automatic privilege [message #419512 is a reply to message #419428] Sun, 23 August 2009 13:34 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
after querying your query

select trigger_name from dba_triggers where owner = 'SYS' and triggering_event like 'CREATE%';

i have found this result


TRIGGER_NAME DESCRIPTION
------------------------------ -----------------------------------
CDC_CREATE_CTABLE_AFTER sys.cdc_create_ctable_after
CDC_CREATE_CTABLE_BEFORE sys.cdc_create_ctable_before
NO_VM_CREATE no_vm_create


out of which first two triggers are enabled and last one is disabled
Re: user created with default automatic privilege [message #419513 is a reply to message #419428] Sun, 23 August 2009 13:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
select trigger_name from dba_triggers where owner = 'SYS' and triggering_event like 'CREATE%';

i have found this result


TRIGGER_NAME DESCRIPTION
------------------------------ -----------------------------------
CDC_CREATE_CTABLE_AFTER sys.cdc_create_ctable_after
CDC_CREATE_CTABLE_BEFORE sys.cdc_create_ctable_before
NO_VM_CREATE no_vm_create


I give up.
I KNOW for a fact the SQL above did not produce the results above

I am not going to waste more of my time deciphering misrepresentations
Re: user created with default automatic privilege [message #419514 is a reply to message #419513] Sun, 23 August 2009 14:09 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i apologize for above output ,the actual output was


TRIGGER_NAME
------------------------
CDC_CREATE_CTABLE_AFTER
CDC_CREATE_CTABLE_BEFORE
NO_VM_CREATE



DESCRIPTION
-------------------------------------------------
sys.cdc_create_ctable_after
sys.cdc_create_ctable_before
no_vm_create

TRIGGERING_EVENT
------------------------------------------------------------------------------
CREATE
CREATE
CREATE



out of which first two where enabled and last one is disabled

[Updated on: Sun, 23 August 2009 14:13]

Report message to a moderator

Re: user created with default automatic privilege [message #419515 is a reply to message #419514] Sun, 23 August 2009 14:21 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
thanks for your support dude ,i have rectify the mistake
Re: user created with default automatic privilege [message #419517 is a reply to message #419428] Sun, 23 August 2009 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Below is from Posting Guidelines

•If you found an answer yourself, post it. That way we know the issue is resolved and we might learn from it.
Re: user created with default automatic privilege [message #419518 is a reply to message #419517] Sun, 23 August 2009 15:39 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
dude i changed the status of trigger NO_VM_CREATE to enable ,at
first it works but now back to same problem ,this whole scenario
making me crazy...but anyway thanks for your assistance
Re: user created with default automatic privilege [message #419558 is a reply to message #419517] Mon, 24 August 2009 04:25 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
can you please tell me blackswan ,that is there is any chance of database been get corrupted or infected with a virus ,because the other database is behaving according to the standards, i appreciate your each reply mate,thanks anyway........... Smile
Re: user created with default automatic privilege [message #419559 is a reply to message #419558] Mon, 24 August 2009 04:37 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There is no chance that your database has been infected with a virus.

If there is not error message in the log files and no trace files are being created, then the chance that your database is corrupt is very small.

It looks very much like there is a trigger granting a role to newly created users.
Can you run
SELECT * FROM USER_ROLE_PRIVS
while connected as one of these new users.
Re: user created with default automatic privilege [message #419573 is a reply to message #419559] Mon, 24 August 2009 05:18 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
yes i run that query after creating and connecting through the new user

SELECT * FROM USER_ROLE_PRIVS

USERNAME
------------------------------
PUBLIC


GRANTED_ROLE
------------------------------
DBA


OS_
---
NO


when i run the query select * from session_roles;
it shows 13 roles granted to that user at the time of user creation


ROLE
------------------------------
DBA
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
WM_ADMIN_ROLE
JAVA_ADMIN
JAVA_DEPLOY

ROLE
------------------------------
XDBADMIN
OLAP_DBA

13 rows selected.


somehow i able to remove that roles by using the command

altet user dolt default role none;

then i run the query

select * from session_privs;

it show three three privilges

PRIVILEGE
-----------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE


out of which i only granted create session privilege to user ,the other privileges unlimited tablespace and create table where assigned to user by default from nowhere

i unable to revoke that two privilege ,when i try to revoke that two privileges ,it troughs an error

revoke create table from dolt
*
ERROR at line 1:
ORA-01952: system privileges not granted to 'dolt'







Re: user created with default automatic privilege [message #419577 is a reply to message #419573] Mon, 24 August 2009 05:59 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I reckon that most of those Roles come from having the DBA role granted.

Connect to your Db as System, or a DBA account, run this and paste the results:
select distinct owner,name
from dba_source 
where type = 'TRIGGER' 
and upper(text) like '%DBA%';

Re: user created with default automatic privilege [message #419580 is a reply to message #419573] Mon, 24 August 2009 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SELECT * FROM USER_ROLE_PRIVS

USERNAME 
------------------------------ 
PUBLIC 


GRANTED_ROLE 
------------------------------
DBA 

You granted DBA to PUBLIC and so everybody is DBA.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Mon, 24 August 2009 06:23]

Report message to a moderator

Re: user created with default automatic privilege [message #419590 is a reply to message #419580] Mon, 24 August 2009 07:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well spotted Michel - I missed that completely.

I think that wins the award for the dumbest thing ever done on a database.
Re: user created with default automatic privilege [message #419595 is a reply to message #419573] Mon, 24 August 2009 07:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
param786 wrote on Mon, 24 August 2009 12:18
yes i run that query after creating and connecting through the new user

SELECT * FROM USER_ROLE_PRIVS

USERNAME
------------------------------
PUBLIC


GRANTED_ROLE
------------------------------
DBA


OS_
---
NO

JRowbottom said
Well spotted Michel - I missed that completely.


See, param786, this is what you get if you fake output. What you showed is NOT the output SQLPlus showed you.
icon14.gif  Re: user created with default automatic privilege [message #419619 is a reply to message #419595] Mon, 24 August 2009 08:54 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
hey, thanx for the help ... it worked... thanx micheal... and JRowbottom

and frank i didn't fake anything.... i manipulate this output so that u people can read this clearly and i,m just a newbie in oracle folks,thanks for your support
Re: user created with default automatic privilege [message #419620 is a reply to message #419595] Mon, 24 August 2009 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What you showed is NOT the output SQLPlus showed you.

It may be:
SQL> drop user test;

User dropped.

SQL> grant dba to public;

Grant succeeded.

SQL> create user test identified by test;

User created.

SQL> connect test/test;
Connected.
TEST> SELECT * FROM USER_ROLE_PRIVS;
USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
PUBLIC                         DBA                            NO  YES NO
PUBLIC                         PLUSTRACE                      NO  YES NO

2 rows selected.

user_roles_privs is defined with:
where sa.grantee# in (userenv('SCHEMAID'),1)

user#=1 is PUBLIC.

Regards
Michel
Re: user created with default automatic privilege [message #419621 is a reply to message #419590] Mon, 24 August 2009 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Well spotted Michel - I missed that completely.

I took benefit of all your questions.

Regards
Michel
Re: user created with default automatic privilege [message #419627 is a reply to message #419620] Mon, 24 August 2009 09:26 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Mon, 24 August 2009 15:56
Quote:
What you showed is NOT the output SQLPlus showed you.

It may be:


I was talking about the way it was "formatted"

I bet that if it had been displayed the way you did it, JRowbottom would have spotted it.
Re: user created with default automatic privilege [message #419629 is a reply to message #419627] Mon, 24 August 2009 09:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank wrote on Mon, 24 August 2009 16:26
Michel Cadot wrote on Mon, 24 August 2009 15:56
Quote:
What you showed is NOT the output SQLPlus showed you.

It may be:


I was talking about the way it was "formatted"

I bet that if it had been displayed the way you did it, JRowbottom would have spotted it.

Oh! I see your point. I think so too.

Regards
Michel

icon14.gif  Re: user created with default automatic privilege [message #419637 is a reply to message #419629] Mon, 24 August 2009 11:40 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i just copy all the data from sql*plus and paste it here ,i didn,t use SQL Formatter...,thanks all of you for your precious assistance
Re: user created with default automatic privilege [message #419640 is a reply to message #419637] Mon, 24 August 2009 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What I posted is the exact copy and paste of SQL*Plus, waht you posted is NOT.

Regards
Michel
icon14.gif  Re: user created with default automatic privilege [message #419774 is a reply to message #419428] Tue, 25 August 2009 09:52 Go to previous messageGo to next message
param786
Messages: 15
Registered: August 2009
Location: chandigarh
Junior Member
i said i manipulated it dude to make it more readable for you people,but in future i will use sql formatter only ,i apologize for inconvenience folks,thanks for your valuable assistance
Re: user created with default automatic privilege [message #420242 is a reply to message #419428] Thu, 27 August 2009 13:39 Go to previous messageGo to next message
apparao1503
Messages: 2
Registered: December 2006
Location: Columbus, OH,USA
Junior Member

Some how the 'PUBLIC' ROLE has been alloted all the system privs.
When a new user is created by default he is alloted the PUBLIC role. Any privilege granted to public automatically becomes a privilege for other users as well.
select * from dba_role_privs where grantee='PUBLIC'
Regards,
Apparao
Re: user created with default automatic privilege [message #420244 is a reply to message #420242] Thu, 27 August 2009 13:52 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Great we see you can repeat what has been posted a couple of days ago.
It is nice you want to help but please read the whole topic before answering.

Regards
Michel

[Updated on: Thu, 27 August 2009 13:53]

Report message to a moderator

Previous Topic: Self Join Using 2 tables
Next Topic: Get the records with alternate workflow value
Goto Forum:
  


Current Time: Sun Dec 11 00:25:48 CST 2016

Total time taken to generate the page: 0.07793 seconds