Wherescape Red and Oracle Express - take 2

The Validate Privileges option in Wherescape Setup Administrator (WSA) is supposed to assist you in getting your admin user granted up and ready to go.

So based on its recommendations you go into the XE home page and tick the following:

• Create Database Link
• Create Materialized View
• Create Procedure
• Create Table
• Create View

and then run a little script as follows:

grant select any table to bob;
grant query rewrite to bob; --why the heck is this deprecated stuff here??
grant execute on sys.dbms_lock to bob;
grant select on sys.v_$session to bob;

and you should now be good to go, right?

Nope. If you haven't created any tablespaces and you don't select any on metadata creation, you will get a ton of errors related to availability of tablespace "USERS". Where did this come from? I didn't specify a tablespace anywhere and there doesn't appear to be a WSA default tablespace option, but WSA has gone and decided to plug it in the metadata creation sql.

The quick and dirty for getting round this is to give bob DBA rights. Thankfully this is just a tickbox away in XE.