As sysdba, how to grant create table to a user for a particular tablespace?
666470Jan 11 2009 — edited Jan 12 2009I made the PRACTICE tablespace and the user SEAN. How do I give SEAN the privilege to create a table in the practice tablespace?
CREATE TABLESPACE PRACTICE
DATAFILE
'F:\DBM\FALLB\DB2046\ORACLE\ADMIN\ORAC...
SIZE 20M
EXTENT MANAGEMENT DICTIONARY DEFAULT STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS 20 PCTINCREASE 0);
CREATE USER SEAN
IDENTIFIED BY SEAN
DEFAULT TABLESPACE PRACTICE;
GRANT CREATE SESSION TO SEAN;
-----------------------------------------------
-----------------------------------------------
GRANT SYSDBA TO SEAN;
+
CONNECT sean/sean@db2046.world as sysdba
works but what if I dont want SEAN to have sysdba privileges?
-----------------------------------------------
-----------------------------------------------
another question would be if I do give SEAN sysdba priviliges and then I log on as sean and then do a
SELECT * FROM TAB;
to view the available tables how can I make it so that I only see the tables that I make myself instead of all of the tables in the database?