Questions tagged [sys]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
189 views

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 ...
eathan's user avatar
  • 23
0 votes
1 answer
239 views

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's user avatar
0 votes
0 answers
177 views

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: ...
Pedrinho Kappaum's user avatar
1 vote
1 answer
3k views

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. ...
iwis's user avatar
  • 113
0 votes
4 answers
4k views

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 ...
r0tt's user avatar
  • 1,008
0 votes
1 answer
758 views

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?
user avatar
1 vote
2 answers
5k views

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 ...
jrdba's user avatar
  • 55
0 votes
1 answer
189 views

Oracle SYS views missing from DB instance [closed]

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 ...
Steven Tang Ti Khoon's user avatar
1 vote
2 answers
294 views

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 ...
J. Doe's user avatar
  • 113
2 votes
1 answer
4k views

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 ...
JHnet's user avatar
  • 123
0 votes
1 answer
2k views

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 ...
Vincent's user avatar
  • 369
1 vote
1 answer
12k views

Why am I getting "Invalid object name 'sys.sysobjvalues'." [duplicate]

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,...
Evan Carroll's user avatar
  • 63.2k
3 votes
1 answer
5k views

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....
artificer's user avatar
  • 285
51 votes
4 answers
97k views

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 ...
Lazer's user avatar
  • 3,361