Server Administration :: How To Give Full Access To Other Schema

Apr 15, 2012

I want to get clear with one thing yesterday i installed oracle9i and dev 2000 to my client.

when they run one report they got stuck with pl/sql compilation errorrep-1247

when i checked that report in the report builder, in the query they are using some other table which is not belongs to that schema,then I give that schema.tablename and compiled, but this is coming for other reports also, then only i came to know that they are acceessin other schema also, how can i sort this out.

can i fix this by givin full access privilige or what privilige can i give to get full access of other schema table.

how can i check in the old database what are all the roles and privileges given to this user,

View 5 Replies


ADVERTISEMENT

Server Administration :: Alter SGA But It Give Error?

Dec 9, 2010

I try to alter the SGA it give me error The Steps which I do show sga

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes

[code]...

View 5 Replies View Related

SQL & PL/SQL :: Give Access Only On 10th Row For Schema2

Mar 26, 2010

I have two schemas.In schema1 i hava a table with 20 records,i want to give access only on 10 th row for schema2.

View 6 Replies View Related

PL/SQL :: Give ROLE Access To Users In Developer Tool?

Oct 5, 2013

How to give ROLE access to users in PL/SQL developer Tool..??

View 3 Replies View Related

Server Administration :: Accessing Single Schema From Multiple Schema Logging?

May 16, 2011

A single master schema where many developers are accessing. all share same password.

now i would like to trace all the changes made by each users. so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema

View 2 Replies View Related

Server Administration :: One Schema Versus Multiple Schema

Feb 1, 2010

single schema setup or multiple schema setups for an application development. Which option is recommended and pros and cons of these methods?

View 4 Replies View Related

SQL & PL/SQL :: Give Grant To Schema Of Different Versions Of Oracle Databases?

Aug 8, 2012

I have a task assigned to "grant select on sys.link$" to a user which exists on 500 different databases.

This needs to be done in Oracle database.

View 6 Replies View Related

Server Administration :: Full Or Incremental Checkpoint

Mar 25, 2012

after i issue the following command,what checkpoint does it trigger?(full checkpoint or incremental checkpoint):

SQL> ALTE SYSTEM SWITCH LOGFILE;

View 1 Replies View Related

PL/SQL :: Table Access Full

Aug 11, 2012

i have query lie below.

select
(SELECT MIC.MICR_BANK_NAME FROM M_ECS_MICR_MST MIC WHERE MIC.PK_MICR_ID = BANK.ECS_MICR_CODE) AS BANKNAME,
, (SELECT PAY.PAYMENTCODE FROM M_ECS_PAYMENT_MODE PAY WHERE TO_CHAR(PAY.ID) = BANK.ECS_FACTORING_HOUSE) AS
[code].....

i have used composite index below column which used in the tbl_bank_statement table.like column name tbl_bank_ statement (policy_ no,ecs_ micr_code,ecs_factoring_house,ecs_mandate_status)

but still this table giving me TABLE ACCESS FULL.

View 3 Replies View Related

PL/SQL :: Index Range Scan And Table Access By Index Rowid Versus Table Access Full

Oct 5, 2013

Let's consider such table that all rows fit into single block:

SQL> create table test as select rownum id, '$'||rownum name from dual connect by level <= 530;
Table created.
SQL> create index i_test on test(id);
Index created.
SQL>
SQL> begin

[code].....

why does approach with full scan take longer even if table occupies only one data block? PS. 11gR2

View 8 Replies View Related

Server Administration :: DBMS_SERVER_ALERT Tablespace Full Alert Timing?

Oct 20, 2013

Tablespace usage alerts are checked every ten minutes. You can request a check every minute when you set the threshold, and confirm that this has been set:

orclz> execute DBMS_SERVER_ALERT.SET_THRESHOLD(-
> metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,-
> warning_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
> warning_value => '50',-
> critical_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
> critical_value => '75',-

[code]....

orclz>but you will still have to wait up to ten minutes for the alert to be raised. know whether this frequency can be changed? And why this particular alert behaves differently from all the others? This is the bahaviour in all releases since server alerts arrived.

View 2 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Server Administration :: Undo Tablespace 100 Percent Full With Offline Extended?

Jul 26, 2010

i'm facing a problem while i'm inserting millions of record from table to table that undo tablespace reach 100% full and execution aborted. , how can free the undo tablespace ??? many of extendes are offline. will it flush automatically ??? or what i should do

View 4 Replies View Related

Server Administration :: Access Logs Via SQL

Jul 14, 2011

I'm currently working on a project in which I do not have permissions to access the Server where the database is installed and configure.Because of company policies, I do not have Admin Rights over Oracle, but I do have an account that can make Selects to DBA_USER_PRIVS for instance.

I would like to know if there is any way to access the database logs to know if there was any kind of problem within the database, because one of my Schemas misteriously went clean (all tables, sequences, triggers, ... vanished)

View 4 Replies View Related

Security :: Create User With Full Access On Default Tablespace?

Aug 12, 2011

i have been trying to create a user with full access on default Tablespace so that i can access all the objects without any restrictions for the new user.

View 7 Replies View Related

Server Administration :: DB Link For One To Many User Access

Sep 14, 2010

I need to create one to many user DB link in oracle 10g. Meaning I have a user A in database 1 and I want to access the objects from user B,C,D in database 2, how to create a public database link so that i can have this one to many user access?

View 8 Replies View Related

Server Administration :: How To Track The Last Access To A Table

Oct 11, 2011

is it possible to track the last access to a table?

View 2 Replies View Related

Server Administration :: DB Link Access To User

Sep 3, 2013

I have login through the sysdba and created dblink and modified the tnsnames.ora for necessary changes. And the it started working correctly and I can able to get the data by selecting it.But when I login with different user that is showing the following error.

ORA-12154: TNS:could not resolve the connect identifier specified

How to resolve this,is there any privileges or permission need to give to that user.

View 5 Replies View Related

Server Administration :: ASM Instance Did Not Access Raw Devices

Sep 28, 2011

I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:

1- Sparc & disks preparation:

# isainfo
sparcv9 sparc
# ls -lL /dev/rdsk/c4t50060E800570B715d0s6
crw-rw---- 1 root sys 336, 14 Sep 28 14:08 /dev/rdsk/c4t50060E800570B715d0s6
# ls -lL /dev/rdsk/c4t50060E800570B715d2s6
crw-r----- 1 root sys 336, 62 Sep 28 14:09 /dev/rdsk/c4t50060E800570B715d2s6
# ls -lL /dev/rdsk/c4t50060E800570B715d3s6

[code]....

Those 6 partitions disks above were supplied to ASM, so, I make mknod to link them.

# ls -lrt /asmdisks
total 0
crw-r--r-- 1 oracle dba 336, 110 Sep 28 15:35 disk6
crw-r--r-- 1 oracle dba 336, 94 Sep 28 15:39 disk5
crw-r--r-- 1 oracle dba 336, 78 Sep 28 15:39 disk4
crw-r--r-- 1 oracle dba 336, 30 Sep 28 15:39 disk3
crw-r--r-- 1 oracle dba 336, 14 Sep 28 15:39 disk2
crw-r--r-- 1 oracle dba 336, 62 Sep 28 15:39 disk1

Well, I go to ASM, but And nothing on Available Disk Groups.

View 2 Replies View Related

Server Administration :: Access Redo Generation After Migrating From 9.2.0 To 10.2.0.4

Sep 14, 2010

We had our production database hosted on Oracle 9.2.0. Few months back we have migrated it to Oracle 10.2.0.4.0. After Migration I have noticed that redo generation has become very very high. In earlier case no. of log files generating in production hours were around 30 where as after migration it become around 200 files per day. I have run statspack report on this database. Report is saying that db block change & disk write is become very high. Parameter timed_statistics has also been set to FALSE. Even then there is not any reduction on no. of log file generation. I had used import export for upgrading the databases.

View 13 Replies View Related

Server Administration :: ORA-16000 / Database Open For Read-only Access

Apr 5, 2010

I am facing a strange issue on 11gR2 (OEL 5.4) standby readonly with apply database.It's throwing 16000: database open for read-only access during SELECT's .

Here is snapshot of errors.

ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access

SQL> l
1* SELECT t0.airportID, t0.archived, t0.assetTag, t0.bluetoothID, t0.cmBundle, t0.createdDate,
t0.currentProductTaskID, t0.ethernetID, t0.failOrReworkCount, t0.highestCompletedTaskTypeID, t0.lastModDate, t0.lastStationID,
t0.modCount, t0.modelID, t0.oemSerialNumber, t0.orgSerialNumber, t0.pdmVersion, t0.preburnComplete,
t0.productID, t0.reworked, t0.secondaryEthernetID,
t0.serialNumber, t0.shipped, t0.specialBuildTypeID,

[code]....

View 7 Replies View Related

Server Administration :: How To Access Active Directory With Oracle Database

Oct 12, 2012

How to access Active directory(Microsoft 2003) with oracle database 11g.

View 1 Replies View Related

Server Administration :: Unable To Access Remote Database Using DBLink

May 21, 2010

We have created a new db link. But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.

We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.

One observation we made is that that particular db link is not getting dropped when we tried to drop it.

View 2 Replies View Related

Server Administration :: Privileges From One Schema To Other

Feb 10, 2012

I have 10 important schemas in my database,and i want to give only select privileges from SCHEMA PRODUSER to other 10 schemas. And also want that the new objects that are created in PRODUSER after granting the privileges are also have select privileges. Is it possible that i should directly grant select privileges from one schema to other without granting via individual objects(script to grant individual privileges from individual objects)

Details are as below:
database version: 9.2.0.8.0
OS version:
Microsoft Windows Server 2003
Standard Edition
Service Pack 2

View 1 Replies View Related

Server Administration :: Schema Comparing Tool

Apr 8, 2012

we have a two different databases at different locations and on different servers, like one in our company with SID='A' and remote database with SID='B', We have recently implemented new module in database 'A' by creating lots of tables, functions, indexes, sequences, synonyms etc and now we need to install this on 'B' but the problem is we have not documented which tables we created, first we need to create a DB link between these two and then we need a tool to compare what are all the tables that we need to create in database 'B' , is there a tool for doing all this.

View 7 Replies View Related

Server Administration :: Difference Between Table_owner And Schema?

Sep 14, 2011

a table can have many schema or just 1 schema which is the table owner?

View 5 Replies View Related

PL/SQL :: Procedure Access From One Schema To Another

Aug 2, 2013

I have created one procedure in SCOTT schema. just i need to see that same procedure information to TEST schema. how its possible.if im using

SELECT DBMS_METADATA.GET_DDL('PROCEDURE','PROC_NAME','SCOTT')

FROM DUAL in scott schema mean i can see that full procedure information,like wise i need to see in TEST schema mean what command i need to use.  

View 20 Replies View Related

Read Access To Schema

Oct 12, 2012

Below is the request i have received from a user -

" Can you setup user <usernmae> in <database>S to have read only access to <applicationname> (CHADBA, CHAS, EMI and SVCM schemas)"

Steps I have followed -

create user <usernmae> identified by password default tablespace USERS temporary tablespace TEMPL;

Grant PRODUCEBILL to <username>;
Grant REPORTING to <username>;
Grant PAYMENT to <username>;
Grant CONNECT to <username>;

My question is as user has request for read only access to specific schemas, so how do I validate them?

View 11 Replies View Related

Server Administration :: How To See Schema User Password In Text

Oct 1, 2012

I need to see all schema users password in a text.I am database admin,but it difficult to remember the password of all users created in single database So we also dont want to change password of all time,table to view password in text. Also we all know we can see using dba_users, but it was showing in hash value i need it in a text

View 3 Replies View Related

Server Administration :: Difference Between A User And Schema On Oracle?

Apr 26, 2010

difference between a user and schema on Oracle.By difference, I do not mean what is a user and what is a schema.

I understand that if we create a user, the schema gets created by default for that user. Does that mean that we cannot create a user/schema alone.

What if I just want to create a user and grant him some read access on an existing schema or just want to create a schema.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved