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


ADVERTISEMENT

Networking And Gateways :: Find Out Users Hostname Who Are Connecting To Database Remotely

Apr 22, 2010

i got to find out the users hostname who are connecting to database through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?

View 8 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

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 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

Enterprise Manager :: How To Use OEM Remotely

Oct 21, 2011

How can I use OEM remotely?

my DB server is on 172.17.1.4 IBM-AIX

and my computer is 172.17.1.53

Because I am tired of using sqlplus :@

View 2 Replies View Related

SQL & PL/SQL :: Grant Privileges Remotely

May 25, 2010

Say we have db1 and db2 two databases installed on two different servers.For internal needs, I have to insert some data from a table t1 on db1 to a table t2 in db2. This can be done by issuing from a user on db1 :

insert into t2@dblink2
select *
from t1;

where dblink2 is a correct database link that points to u2 (the t2 owner for example) on db2.

Now what I want to do is to grant privileges remotely.Is there a way to issue somthing like

execute@dblink2 'grant select on t2 to public';

It would be like u2 has issued the statment...

I don't want to use OS scripts (.sh or .bat).

View 14 Replies View Related

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

Enterprise Manager :: Managing OEM Remotely

Aug 23, 2013

I want to manage my database remotely, through Internet. Is it possible to do that with OEM? Where can I find information related to this? Is there another monitoring software that allows me to perform this?

View 10 Replies View Related

Cannot Connect Oracle Instance Remotely In LAN

Jun 24, 2012

I have installed oracle 10g database in the my local laptop ( Windows 7) . This laptop is in LAN. I am not able to connect from other machines in LAN. When i open sqlplus, SQL Developer from the same machine, i was able to login to the instance.

But when i want to login from the other machines in LAN. I was not able to connect. I was able to ping the server on which the database was installed from other machines. why i am not able to connect ?

View 8 Replies View Related

Not Able To Connect DB Remotely Using Oracle Client?

Aug 20, 2013

I am trying to connect to database remotely. I have installed Oracle client on my local machine(Windows 7) and trying to connect to db.

I am able to do tnsping. Below is the log.

But when i try to connect i am getting ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error.

Below is the complete log.

C:\Windows\System32>tnsping DEVDB

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-AUG-2

013 14:18:42

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

D:\app\swanand_kulkarni\product\11.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO

COL=TCP)(HOST=10.111.0.121)(PORT=1521)))

OK (560 msec)

C:\Windows\System32>sqlplus test1/********@devdb

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 20 14:18:47 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

View 8 Replies View Related

Networking And Gateways :: Connect Remotely Database?

Jul 14, 2010

i have a inventory system and trying to connect remote database one by one throught two static ips. If first ip is not ping then go to 2nd ip only when open the login.fmx page

following examples are my tnsnames.ora

IP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.12)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

IP2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.13)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

i am not understand what i write the code on-logon trigger

View 8 Replies View Related

Networking And Gateways :: DBCA Installation And Remotely From Off-shore?

Sep 22, 2011

Iam facing a issue on DBCA Installation, when i tried remotely from off-shore. Steps I followed

a. I Connected a onsite desktop through a remote desktop connection (RDP) by using Corp-VPN from off-shore.
b. In the Remote Desktop, again by using production / Model VPN , connected the server which i need to Install DBCA
c. Using X11-Forwarding of putty, Started the DBCA installation.
d. Applied all the Parameters and on Finally clicking Finish to Start the database Creation, Finish button not responding and i can't continue the DBCA Installation.

View 1 Replies View Related

Connecting To DB Remotely Through Toad Using Oracle Instant Client?

May 5, 2013

trying to connect to DB remotely through Toad..

"instantclient" already downloaded and configured as below :

dll files like "oci.dll,... etc" are here : C:Oracleinstantclientinstantclient_11_2
Created both tnsnames.ora & listener.ora are here : C:Oracleinstantclient
etworkadmin

And did the below in user/system variables :

User Variables :
=========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"

System Variables :
===========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"
ORACLE_HOME with value "C:Oracleinstantclient"
Path edited and added this value "C:Oracleinstantclientinstantclient_11_2"

But i am still facing the below error :

ORA-12541: TNS:no listener

View 21 Replies View Related

SQL & PL/SQL :: How To Add Tables Users

Jun 3, 2011

I have 4 tables as follows.

1.Deploybase(DeployId)
2.LicenseHistory(DeployId,UserId)
3.Users(UserId,User_Detail_id)
4.UserDetails(User_Detail_id)

Tables are joined using below joins.

Deploybase.DeployId=LicenseHistory.DeployId
LicenseHistory.User_id=Users.User_id
Users.User_Detail_id=UserDetails.User_Detail_id

When I join LicenseHistory,Users,UserDetails, all records are unique.

But the issues is: LicenseHistory table has duplicate records for DeployId column which is used to join table Deploybase. As a result when I join it to Deploybase, it gives me repeating entries which I don't want

I want Comments from LicenseHistory,Login from Users and User_name from UserDetails. There are multiple columns from 1st table i.e. Deploybase which I need.After reading on Exists operator, I made following query.

Select DeployId,comment from (select comments as comment,deploy_id as DeployId from LicenseHistory slh where exists (select deploy_id from symdb.symdb_deploybase sdb) and slh.comments is not null)

Above query gives me results from LicenseHistory table only. But I don't know how to add tables Users,UserDetails

View 1 Replies View Related

SQL & PL/SQL :: How To Logout All Users

Dec 23, 2011

HOW TO LOGOUT ALL USERS FROM ORACLE IN ONE COMMAND

View 2 Replies View Related

SQL & PL/SQL :: How To Extract The Rights Of Users On ERP

Mar 2, 2013

I would like to extract the user rights from the ERP that I use with SQL/Oracle.

There are 3 databases. The first gives me all the users with the main key id_user. The second one gives me the actions with the main key id_action. The third one only gives me what the user can't do.

I would like to know all the actions that all users can do or not.

The result must be something like:

Action 1
User 1 Yes
User 2 No

Action 2
User 1 No
User 2 Yes
....

View 9 Replies View Related

Security :: Password Of Users In 11g?

Jun 2, 2011

how to see password of users in 11g

View 11 Replies View Related

SQL & PL/SQL :: Checking Users Input?

Dec 8, 2010

I want to ask for a password from the user so they can access their account, however I want the password to have constraints on it. For example I want the user input to between 6 and 12 characters in length containing at least one number and one letter.

View 2 Replies View Related

Default Oracle Users

Oct 2, 2013

I am trying to find out if there is a definite way to find out (by querying database) which database users have been created by Oracle (either during installation or as part of patching or adding new feature) and which database users have been created by DBAs.

I have looked into the documentation but could not find anything relevant. Ideally, I would like to know if this can be done for any versions starting from 9iR2.

View 7 Replies View Related

Select Access To Users

May 2, 2013

Are you aware of any "Best Practice Document" to grant select accesses to users on databases. These users are developers which select data out of database for the investigation and application bug fix.

From time to time user want more and more access to different tables so that they can do investigation properly.

View 2 Replies View Related

Users Getting Error When Connecting To DB

Dec 26, 2012

The users are getting an error when connecting to the DB. I'm also not able to connect thru sqlplus . I get the message

$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 26 14:39:55 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

ERROR:
ORA-01075: you are currently logged on

ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes o bytes of shared memory ("","","","")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim hea

I need to restart the DB.

View 5 Replies View Related

PL/SQL :: Only Get Users That Match All Links

Jul 17, 2013

Seemingly a very simple problem, but I can't seem to figure it out. Table below is a table that holds UserId' s and LinkId's.  

CREATE TABLE UserLink (UserId NUMBER, LinkId NUMBER );
ALTER TABLE UserLink ADD PRIMARY KEY (UserId, LinkId);
INSERT INTO UserLink VALUES (1, 1);
INSERT INTO UserLink VALUES (1, 2);
INSERT INTO UserLink VALUES (3, 1);
INSERT INTO UserLink VALUES (4, 1);

I'm looking for a query in which I can plug a List of LinkId's that outputs only users that have a relationship with ALL LinkId's provided. In this example you may assume that the List is equal to (1, 2), but you can't make any assumptions about the size of the list, other than size != 0. The query to find users that match ANY of the provided LinkId's is quite simple:  

SELECT UserId FROM UserLink
WHERE LinkId IN (1,2)

The correct query should output: 

USERID
------
1

And it should work for any size > 0 list of values.

View 6 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

Dropping Users And Recreating?

Jun 18, 2012

we are refreshing data base for our application from the base load,Every time when ever there is refresh required we need to drop the users and recreate every thing from the base load. For this we need to kill the sessions and drop the users ,Putting the instance in the restricted mode and refreshing the db.Some time when ever During the killing and dropping process there are some errors like you can not drop the users which is currently connected .

set termout on
set echo on
spool Kill_sessions_drop_users.log
DECLARE

[code]...

how to get rid of this

View 6 Replies View Related

Locking Users By A Table Field Value

Dec 27, 2006

We have a table with several columns (id, title, description, area).The data in the table looks like this

1 sometitle1 description1 USA
2 sometitle2 description2 Germany
3 sometitle3 description3 Japan
4 sometitle4 description4 Honduras

We have Oracle users with their usernames and password. We would like to lock every single user to a certain area.Example:

user 1 may see only records, where AREA=USA
user 2 may see only records, where AREA=Honduras

How can I do this in Oracle. I am using Oracle Enterprise 9.2

View 1 Replies View Related

Fast Method To Drop Many Users

Oct 21, 2010

I have 2 tests Oracle instances (a 10g and a 11g) in which somebody added many users (almost 50k), every user having a TEST table with no rows in its schema.

I have to drop these users without recreating the instances, but DROP USER username CASCADE is taking almost 1 minute for each user. This will take me to almost a month.

View 2 Replies View Related

List All Users That Have Privileges On A Table

Aug 6, 2011

Is possible to list all users that have any privilege on a specific table?

View 2 Replies View Related

SQL & PL/SQL :: Altering One Record Concurrently By Two Users

Feb 28, 2013

What will happen when a record in a table is getting update by one user and at the same time if another user trying to update the same record?

View 9 Replies View Related

SQL & PL/SQL :: Dropping Users - Queue Tables

Dec 9, 2010

I am trying to drop a user but i get the following error

*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

A couple of questions on this error:

- I did a search on the forum and the thread [URL] appears to have a solution to it by using

DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'DEF$_AQCALL', force =>TRUE);

What i am not sure of is which queue will the above statement drop if run as sys and there are multiple schemas with different schema names but with the same queue name?

- We recently rebuilt the database server and prior to the rebuild i have always managed to drop a user without the above error. Is it likely that some setting somewhere is changed?

View 2 Replies View Related







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