|
|
|
Re: Unable to grant Admin privileges on SQL Developer 12c [message #666760 is a reply to message #666759] |
Fri, 24 November 2017 01:58 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
What do you call "myself"? You should create a user and grant certain privileges so that you could connect to it and, actually, do something. Here's how: connect as a privileged user (SYS) and check which tablespace(s) you have, and then use them in CREATE USER script:
SELECT tablespace_name FROM dba_tablespaces;
CREATE USER dave IDENTIFIED BY dave
DEFAULT TABLESPACE user_data
TEMPORARY TABLESPACE temp
PROFILE DEFAULT
QUOTA UNLIMITED ON user_data;
GRANT CREATE SESSION TO dave;
GRANT CREATE TABLE TO dave;
GRANT CREATE PROCEDURE TO dave;
After you do that (and verify that user has been created), you can connect to it (either via SQL*Plus or SQL Developer) and try to, for example, create a table, insert data into it, ....
Once you find out that you need another privilege, connect as SYS again and grant yourself what you need (such as "GRANT CREATE VIEW TO dave").
|
|
|
|
|
Re: Unable to grant Admin privileges on SQL Developer 12c [message #666763 is a reply to message #666762] |
Fri, 24 November 2017 02:20 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
True and I agree with you, that should be the best practice. Perhaps I shouldn't have said that at all, but hey - that's the life.
I'm just a developer so those smart DBA things are managed by someone else. On my own computer & in my own XE database I simply use SYS.
|
|
|