Questions tagged [sys]
15 questions
51
votes
4 answers
What is the difference between sys and system accounts in Oracle databases?
There are two ways to connect to Oracle as an administrator using SQL Plus:
sqlplus sys as sysdba
sqlplus system/manager
These accounts should be used for different purposes, I suppose.
Which tasks are these two schemas meant for? When should I…
Lazer
- 3,361
- 15
- 43
- 53
3
votes
1 answer
How does the SYS user get the SYSDBA privilege?
I am using Oracle 12c on Linux. Using the enterprise manager database express, I am looking at the list of privileges and roles for the SYS user but I haven’t found the SYSDBA privilege assigned there.
Is the SYS user a member of an Oracle role or…
artificer
- 285
- 1
- 4
- 9
2
votes
1 answer
How to fix the sys.host_summary table in MariaDB 10.3.13
using mysqldump while doing a backup gives the following error:
mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK…
JHnet
- 123
- 1
- 4
2
votes
1 answer
Why am I getting "Invalid object name 'sys.sysobjvalues'."
When I run
SELECT OBJECT_DEFINITION(OBJECT_ID('sys.assembly_files'));
I can see that there is a self-join on sys.sysobjvalues, but when I try to select that table I get,
Msg 208, Level 16, State 1, Line 1
Invalid object name…
Evan Carroll
- 65,432
- 50
- 254
- 507
1
vote
1 answer
How are the DBA, SYSDBA, SYSOPER roles and SYS, SYSTEM users related in Oracle?
I don't know if I correctly understand the privileges of these built-in roles and users, but this is a list of the information that I have found:
The DBA and SYSDBA roles enable you to do everything. If this is true, then why are there two names…
iwis
- 113
- 1
- 5
1
vote
2 answers
Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User
I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error.
My trigger:
CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME
AFTER LOGON ON DATABASE
DECLARE
asd1 NUMBER;
asd2…
jrdba
- 55
- 1
- 15
1
vote
2 answers
Does restoring a database in Microsoft SQL Server add objects to Resource Database?
As far as I know the resource database contains information on all objects in its server instance, so I would think it's only natural that when you restore a database from a backup file, part of the process would be to register its objects in the…
J. Doe
- 113
- 2
0
votes
1 answer
SYS user getting ORA-01017 (invalid username/password; logon denied) even putting right password in Oracle 19c
→ OS: Oracle Linux Server release 8.7
→ DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0
After cloning a virtual machine that we can connect normally on sqlplus with sys user, we cannot say the same…
Alan Homobono
- 11
- 2
0
votes
2 answers
SYS password has expired and cannot be changed due to ORA-00257: Archiver error
In the past : When I had once the error ORA-00257: Archiver error, I had resolved it using the RMAN command:
rman target sys/1234
delete archivelog all;
This time , when I try to connect to rman target:
rman target sys/1234
I get the…
eathan
- 23
- 6
0
votes
1 answer
Why is the SYS user granted both the DBA role and the SYSDBA privilege?
If the SYSDBA privilege gives the grantee ultimate authority, then why does the SYS user also have the DBA role in addition to the SYSDBA privilege?
Mehdi Charife
- 131
- 1
- 12
0
votes
0 answers
Grant for locking sys user on Oracle Database
I would like to know what GRANT is required to block the SYS user, as i have a common user in the database.
GRANT ALTER USER enabled me to block only the SYSTEM, but it returns the error ORA-01031: insufficient privileges when trying to block the…
0
votes
4 answers
What privileges do I need to change the password of sys in an Oracle Database?
Our identity management tool wants to change the sys password regularly. It fails with the ORA-01031. What privileges or roles do I need to grant the identity management tool user to be able to change the sys password?
r0tt
- 1,078
- 7
- 32
- 54
0
votes
1 answer
How to restore by-default saved 'sys' database in MySQL 8.0?
By mistake I deleted by-default saved 'sys' database in Mysql version 8.0.21 So, how to restore it?
Infinitygirl
0
votes
1 answer
Oracle SYS views missing from DB instance
Hi i have a question but not sure what the problem was and how it happened though.
The initial error when i logged in the DB dev machine was ORA-00942: table or view does not exists. Some of the system views that we tried to access gave a…
Steven Tang Ti Khoon
- 101
- 1
0
votes
1 answer
What is the safest way to install the sys schema on a production server?
The reason I'm asking is because I need to install the sys schema on my database so that I can utilize performance_schema because I'm hoping that will help me figure out why mysql is crashing every 30 minutes exactly.
I am running MySQL 5.5.45 on…
Vincent
- 389
- 1
- 4
- 15