Forms :: Create Different Database Users Like STORE / PAYROLL

Apr 12, 2011

I create different database users like STORE, PAYROLL, GL , SYSADMIN, COMMON to contain objects accordingly then I create another user ABC and grant DBA privileges to all users.

After that I grant SELECT/INSERT/UPDATE/DELETE privileges on each and every objects of STORE/PAYROLL/GL/SYSADMIN/COMMON users to ABC then create synonyms of STORE/PAYROLL/GL/SYSADMIN/COMMON users objects into ABC.

Actually, I want to use single user of ABC to build/execute my application but I think I am doing something wrong because whenever I tried to compile my form, its showing this error.

View 8 Replies


ADVERTISEMENT

Create As Many As 100 Database With Upto 100 Users (max) For Each Database As Client

Aug 25, 2010

I have CPU based Oracle server license. In this case as per license policies of Oracle I can have unlimited database with unlimited users connecting it.

I need to create as many as 100 database with upto 100 users (max) for each database as client. What is the recommended hardware for this server? CPU/ RAM/Harddisk, recommended chipset on the motherboard (in case of database storage capacity required is not high typically - 20 GB is OK per database - average), redundancy is critical, also Oracle database vault is going to be installed; as security is of prime importance between users of different database. Which specific server models from specific vendors like IBM/ Dell/ HP are good ones for this purpose?

View 2 Replies View Related

Forms :: Sending Employee PayRoll Slip

Jan 21, 2012

I am looking to send all employees in the company their payroll slip directly to their email IDs, so I need to built a producer can :

1- Generate their slips and save it into PDF files with each employee number .
2- send an email message to each employee with his slip.

View 2 Replies View Related

Forms :: Create A Form To Store Any Excel / Word Files?

Jul 1, 2011

i m using oracle 10g forms.

i want to create a form where i can store any excel / word etc files.

View 6 Replies View Related

How To Store Space After Dropping Objects And Users To Maintain Storage Requirement

Jan 11, 2013

There is a scenario: I dropped all objects of 3 users and dropped other 2 users and then I checked the space from dba_segments it reflects decreased space which is perfectly fine. Problem is that when I checked the space of physical datafile on disk it remains same. How can I restore or shrink or regained the space after dropping objects and users to maintain my storage requirements.

View 1 Replies View Related

Application Express :: Store Encrypted Numeric Value And Make Unencrypted Value Visible To Just Some Users In Apex

Jul 3, 2013

I'm looking for a way to store an encypted numeric value in one field in a table (so that it appears encrypted even to a DBA) and to display the unencypted value in Apex forms and interactive reports for some users but not others.

View 4 Replies View Related

Forms :: How To Store PDF In Database

Mar 23, 2010

I want to store files in the database using oracle forms 6i. The file may be in the form of .pdf .

Its possible, if yes How to code in form.

View 2 Replies View Related

Forms :: How To Store PDF File In Database

Dec 18, 2010

I want to store pdf file in table using forms 6i. Then i want to open and view it in Acrobat Reader. using Forms 6i only.

View 1 Replies View Related

Forms :: Code To Store Images Inside Database

Jan 11, 2011

//To load an image from the Hard Disk
//Level : Item
//Type : Trigger
//Name : When Button Pressed
Declare
[code]......

Now what should be the code to store this image from the image box inside the database? I done a lot of time with Oracle Data Base 11g with the Form Builder 6i and 10g but all in vain . No image store inside the database but browse button work well.

View 10 Replies View Related

Forms :: Transaction Data Which Should Store Temporarily In Database?

Sep 17, 2013

I have a Data entry form which is a multirecord block;

Question: for example that form has 10 to 25 fields or columns more than that all the data has been entered, but before committing or saving that form i need to cross check the the data with a select query, whether the data entered is correct or not but before committing, that data it should be posted into that table if i find that one data is entered wrongly then i will modify that and again cross check and save the transaction permanently into the database table?

View 11 Replies View Related

PL/SQL :: How To Create New Users Remotely

Feb 27, 2013

I've been issuing commands like these by using a session on my guest Oracle VM that is hosted by Windows 8.

sqlplus / as sysdba
create user PocketGuide3rdEd identified by top-secret-password ;
grant connect to PocketGuide3rdEd ;
grant create table to PocketGuide3rdEd ;
grant create view to PocketGuide3rdEd ;
grant create trigger to PocketGuide3rdEd ;
grant create sequence to PocketGuide3rdEd ;
grant unlimited tablespace to PocketGuide3rdEd ;

I've discovered that I cannot do "sqlplus / as sysdba" remotely. Is there a way I can create another account like sysdba that can issue the above commands from windows so I don't have to log into the oracle guest VM?

View 4 Replies View Related

Security :: Create Various Users On A Schema

Nov 19, 2010

I do a schema in oracle ... an m my question is if I can create 2 o more users for access to a schema..for example i have schema Project and i need that one administrator and 2 more users with others permission.

View 3 Replies View Related

Server Utilities :: ORA-01658 / Unable To Create INITIAL Extent For Segment In Tablespace USERS

Apr 4, 2013

while importing data i got this error in my log file.and i cannot import my data successfuly

in my log file error i found like this

ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
IMP-00017: following statement failed with ORACLE error 1658:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
IMP-00017: following statement failed with ORACLE error 1658:

i can import my data using imp utility using this syntax

C:UsersAdministrator>imp tiger/****@tcs file=E:DUMP s.
dmp log=E:DUMP s.log fromuser=tiger121 touser=tiger statistics=none

this my user tiger default tablespace its uses and its a auto extend on and locally managed tablespace,and i have enough space on my drive also.

View 21 Replies View Related

SQL & PL/SQL :: How To Store Special Character In Database

Aug 19, 2010

i want to store special characters in database. i have tried following but not succeed. how to store and retrieve it. Herewith i'm posting my try.I want to store and retrieve following character.

SQL> select nchr(181) from dual;

N
-
µ

SQL> create table temp (uom varchar2(10));

Table created.

SQL> insert into temp values(nchr(181));

1 row created.

SQL> commit;

Commit complete.

SQL> select * from temp;

UOM
----------
?

here i'm getting the '?' but i want 'µ'.

View 2 Replies View Related

Store Video Files In Database?

Oct 3, 2012

In my project I am storing everything in database BLOB column.Everything includes images,documents,videos and any thing uploaded from form.

video should not be save in database.I want to know it is good idea to store everything in database BLOB column?

View 4 Replies View Related

Forms :: Where To Create Database Link

Jun 18, 2013

Usually where should we create the database link? In the production or development? create public database link dblinkname connect to user_in_db2 identified by password_in_db2 using 'tnsentry name in db2'; In production or development?

View 2 Replies View Related

Store Data In CLOD Data Type - How To Create A Unique Index

May 20, 2013

We have been recommended to store data in CLOD data type.

Sample data: 1:2:2000000:20000:4455:000099:444:099999:....etc it will grow to a large number.

We want to create a Unique index, for functional reason. Is it advised to create a unique index on a CLOB datatype?

View 2 Replies View Related

Security :: Where To Store Static SQL (Application Or Database) And Why

Feb 6, 2013

understanding where to store the static SQL code (Database or Application).Consider a scenario, that I am executing a simple SQL from Java which is returning some value, and it will not be changed in future.

should I store this sql in java application code or in database in form of procedure/function and returning the result to Java. Is there any security/performance impact?

View 3 Replies View Related

SQL & PL/SQL :: How Many Users Can Connect With Database

Apr 23, 2010

I want to know what will be the performance of my DB before loading data and how many users can connect with my database.

View 7 Replies View Related

SQL & PL/SQL :: How To Store External File (XLS / Doc / PDF) Format In Oracle Database

Feb 1, 2011

I want to stored the excel or ms word document in oracle database. Is it possible to view that file from database. If i export full database it is included in that dmp.

View 5 Replies View Related

How To Limit Users From Connecting To Database

Aug 14, 2012

i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.

View 6 Replies View Related

Globalization :: How To Store India Regional Language In Oracle Database

Mar 5, 2013

How can we store data in Indian regional languages in Oracle database. We are using Oracle 10g.

Also i need to know can we convert existing data in oracle to local language ?

View 2 Replies View Related

Server Administration :: How To Get Password For Database Users

Nov 24, 2010

get the actual password for the database users. If we talk about the dba_users account we have password in the encrypted form how to decrypt them and get actual password.

View 6 Replies View Related

Application Express :: Adding Users To A Database?

Nov 7, 2013

I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g. 

View 10 Replies View Related

Server Administration :: How To Get Size Of All 80 Users From Database

Mar 19, 2012

select username,account_status,default_tablespace from dba_users;

The ran the above query and it return 80 users but when i ran below query it shows just 14 rows.

select owner,sum(bytes)/(1024*1024) "GB" from dba_segments group by owner;how to get the size of all 80 users from database ?

View 2 Replies View Related

Assign Different Profile For Oracle Database Users According To Their Job Functions

Apr 10, 2011

it is a good practise to assign different profile for oracle database users according to their job functions.what could be the resons for that?

View 3 Replies View Related

SQL & PL/SQL :: To Find Time At Which Query Fired By Any Of Users In Database

Oct 25, 2010

I have 10 users in my database, I need to find the time at which a query is fired by any of the users in the database. provide the query for this? I think i have to use V$sql,v$sqlarea or v$sql.

View 1 Replies View Related

SQL & PL/SQL :: Created 2 Users Named User_a And User_b In Database

Mar 2, 2012

I have created 2 users named "user_a" and "user_b" in my database and i gave "connect","dba" and "resource" roles to both users,then i created a table,synonym in user_a and i observe that user_b can also access this table and synonym of user_a without "granting" to "user_b", how it is possible. is it because of any of above role?

View 12 Replies View Related

Security :: Check Users / IPs Who Connect To Database In Specific Time

Jan 22, 2013

Is there a way where I can check users/IPs who connect to the database in a specific time 2 days ago?

View 5 Replies View Related

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

Dec 27, 2012

how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.

View 1 Replies View Related







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