How to get SYSDBA privileges???
Hi,
I can't change shared_pool parameters because I'm not connected as SYSDBA though my user account is a member of DBA role. I tried ro connect as NT admin - no much help either.
Manual says: 'To connect as SYSOPER or SYSDBA using OS authentication you do not need the SYSOPER or SYSDBA system privileges. Instead, the server verifies that you have been granted the appropriate OSDBA or OSOPER roles at the operating system level.'
Should I create OSDBA or OSOPER roles in NT and be a member of them?
I created to blank role like above and add myself as the user - didn't work out. Probably I miss something.
What privileges should NT admin grant to the roles?
I'm stuck please help ))
Thanks in advance
Marina