All Questions
34 questions
0
votes
2
answers
1k
views
Unable to connect to Oracle user in pluggable database
for some reason, i am unable to connect with any user that I create. their account status is also unlocked.
I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
- 62
0
votes
0
answers
2k
views
ORA 01918: user '...' does not exist
I am new to Oracle DB and I am currently working with Oracle Database 21c express edition.
After the installation, I created a common user "C##OLUAKIN" so that I don't have to do my work on ...
0
votes
0
answers
179
views
Can only use Oracle user when logged in as SYSDBA
I've just been setting up Oracle 19c on my Windows 10 Pro desktop following a hard drive failure. The install itself went well and I could log in with / as sysdba fine, but every user I seem to add ...
- 173
0
votes
0
answers
92
views
Can a user connected as sysdba always bypass auditing mechanisms?
Can a user connected as sysdba always bypass auditing mechanisms? What could be done to minimize (or prevent) auditing prevention?
- 131
0
votes
3
answers
141
views
Store First and Lastname (Fullname) for Oracle Users?
Is it possible to store first-/last-/fullnames and possibly additional information of/for oracle user accounts in oracle?
I look at the table dba_users but it does not contain such information.
I need ...
- 4,807
-4
votes
1
answer
56
views
create a oracle database user with no object in tablespace [closed]
Create user Sara with a password of sara. Make sure that any objects not created
in the system tablespace and Sara can log in and create objects up to 10M in size in the MYUSERS.
how to create a ...
0
votes
2
answers
207
views
How to make a restricted view in oracle?
I had to provide data for an application schema, but there is a requirement that the applications connecting using that schema user cannot query more than five rows at a time, the application queries ...
- 99
0
votes
0
answers
389
views
See Max Simultaneous Sessions Per User
In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
- 325
0
votes
1
answer
694
views
Data from other user not visible
I am using Oracle and SQL Developer to create a database. I am fairly new to SQL, so this may be a simple question. I have my SYSTEM user, who owns several tables, for example this one:
CREATE TABLE ...
0
votes
0
answers
121
views
Create non-sysdba user that can grant tablespace to other users
I am creating an Oracle role with Admin option Grants so that user with this role assigned, will not be a full sysdba but will be able to create other users and grant them permissions.
What I ...
- 216
0
votes
1
answer
760
views
How to quota a CDB only tablespace to a CDB user?
I can create a CDB tablespace like this: (all using: sqlplus / as sysdba)
-- create unique table space for admin
CREATE TABLESPACE admints DATAFILE '/path/to/admints.dbf' SIZE 20M AUTOEXTEND ON;
I ...
- 884
-1
votes
2
answers
719
views
How to create a same user in different PDB while it exists in other PDBs?
I have a list of 100 PDBs in the CDB, say the account_user exists in 50 PDBs and to create the same account_user in other 50 PDBs instead of logging into each PDB and creating user, is there a way to ...
0
votes
2
answers
71
views
Creating roles and granting rights to the role
I wanted to create a role called "user_updates" and this role should have the rights "table_note_updates".
The rights called "table_note_updates" is already available in ...
1
vote
1
answer
972
views
Changing default permanent USERS tablespace to bigfile
I'm trying to build an oracle database server but it's setting up the users tablespace as a smallfile. How can I either install brand new database with users being bigfile or changing the existing ...
- 11
0
votes
1
answer
9k
views
How to find admin user of pluggable database in Oracle 12c up
I'm creating a script and I need to know what is the admin user of pluggable database. I don't find nothing about it in documentation.
Other question is, what happen if I drop a admin user of the ...
- 801
0
votes
1
answer
330
views
Are their any default privilege in Oracle for users?
I want to grant new users in Oracle the normal rules, for example, create a table, delete table update, in general, the default CRUD operations.
Every time I do this manually by running a grant script....
- 140
1
vote
2
answers
588
views
Does an Oracle user have all privileges in its schema?
I'm learning Oracle and did some testing. I used the sys user and created a table t in the scott schema and I found t's owner is scott, and scott has full access to t. I want to confirm, does scott ...
- 2,062
0
votes
1
answer
7k
views
What's the difference between aud$ and dba_audit_trail tables in Oracle database?
I'm studying about audit in Oracle database and when I configure the audit using audit_trail = db the Oracle stores in the two tables
- 801
2
votes
2
answers
411
views
How can to make a new user see table in existing schema [closed]
I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this ...
- 21
0
votes
1
answer
211
views
How to create a database user for oracle 11g on windows 8?
I am new to oracle database and therefore is trying to follow the office guide. (link to the guide) However, it seems that the guide is for Windows 7, so in step 2 - creating database user, it says:
...
- 101
2
votes
2
answers
902
views
One user for all database applications
We are in a process of upgrading our SQL Server database. We are also ditching the Oracle databases that we had and are migrating all the databases to SQL Server 2016.
The internal db structure is ...
- 133
0
votes
1
answer
44
views
A trigger that show the user that has made an insertion
I have the following code
create table o_c(
op_id NUMBER(10,0) PRIMARY KEY NOT NULL,
n_c VARCHAR2(50) NOT NULL,
op VARCHAR2(500) NOT NULL,
amount NUMBER(9,2)
);
create table a_o(
a_id NUMBER(10,0) ...
- 1
0
votes
1
answer
193
views
ORA-01017 error when conecting to Oracle Database Standard Edition 2.12.2.0.1.0 for Microsoft Windows x64 (64-bit)
I've installed and created non-CDB database (single tenant) database. Created a user account using the SYS user, granted it the CONNECT and CREATE SESSION roles. When I attempt to login using the ...
- 1
0
votes
2
answers
6k
views
Oracle Schema Privileges Other Users
I have a user with only CONNECT privileges and I'd like to know if RESOURCE would be enough to query objects in other schemas and create objects in my own schema based on that.
i.e.: create a view in ...
1
vote
1
answer
2k
views
Why doesn't Oracle show my privileges?
I have a user that is able to drop, alter, create tables and indexes. But when I list the privileges for my Oracle user it does not show any CREATE TABLE or other such privileges. How am I able to do ...
- 3,327
0
votes
1
answer
3k
views
List certain user ids and drop them in Oracle
How do I list certain user ids and drop them?
For instance, I want to list user ids directly connected to database, in Oracle, and not any functional id.
I need to write a script for the automation
...
0
votes
1
answer
274
views
How do I host and separate multiple projects on one Oracle Database?
From Difference between database vs user vs schema
I'm trying to understand the concepts of the schema, user and database.
My current understanding is you cannot create a schema separately.
You can ...
- 439
0
votes
2
answers
1k
views
How to prevent users other than DBAs from creating database links
To begin, please keep in mind that I am a very green DBA. I have done prior research and have not really found anything too promising, or maybe it just seems that way because I am still struggling in ...
- 207
1
vote
1
answer
142
views
Simplest way to log in as Oracle user different from schema user and still see all tables,... of schema?
What is the simplest way to log in as user X and see all tables,... of schema Y as if they belonged to X?
With an Oracle 11g database, I would like to log into the database using user X but all the ...
- 2,420
0
votes
1
answer
5k
views
Remove profile from user
How do I clear user's profile?
I found how I can drop the profile (also using CASCADE), but I want to keep the profile and just remove it from the user.
- 139
1
vote
2
answers
498
views
Audit table insert restriction
So I'm trying to create my own audit table for some user management analysis and stumbled across a little problem. I use this trigger
CREATE OR REPLACE
TRIGGER usr_t_audit_user_alnd
AFTER LOGON ...
- 231
2
votes
1
answer
9k
views
Creating a USER using the imp command [duplicate]
I was told I can use exp to export a certain USER, then DROP the user and with the imp command I can recreate that USER with all of its tables.
Is it true?
How do I do it?
I already have an ADMIN ...
- 141
2
votes
2
answers
25k
views
110
votes
6
answers
295k
views
Difference between database vs user vs schema
What is the difference (if any) between a database, a user, and a schema?
- 1,565