Youexecutethefollowingsetofcommandstocreateadatabaseuserandtograntthesystemprivilegesinyourproductionenvironment.
SQL>CREATEUSERuser01
IDENTIFIEDBYoracleDEFAULTTABLESPACEtbs1
TEMPORARYTABLESPACEtempPROFILEdefault
/
SQL>GRANTcreatesession,createtableTOuser01;
Whileexecutingthecommandtocreateatable,theusergetsthefollowingerrormessageandtheCREATETABLE..commandfails.
ERRORatline1:
ORA-01950:noprivilegesontablespace
Whatcouldbethepossiblereasonforthiserrormessage?()