Access Problem

Database
N/A

Access Problem

Hi All,

I am facing an error while executing a macro which has a create table statement inside it. :
" Failure 3524 An owner referenced by user does not have CREATE TABLE WITH GRANT OPTION access to database X ".

I tried every possible means to grant access to the user & its owner and all its hierarchies above but still the error hasn't gone.

Could any body please help and let me know if anything else is needed to resolve this issue ?

Thanks for your responses.
6 REPLIES
N/A

Re: Access Problem

Hi Ansh,
the database where the macro is located needs that access right.

Dieter
N/A

Re: Access Problem

Hi Dieter,

The database of the macro and the table getting created are both same.
N/A

Re: Access Problem

Hi Ansh,
but you still have to submit
GRANT CREATE TABLE ON dbname TO dbnamr WITH GRANT OPTION

Dieter
N/A

Re: Access Problem

Hi Dieter,

We have already executed these statements infact we have given grant access to all the onwers in the hierarchy but all in vain..
N/A

Re: Access Problem

Hi Ansh,
you should better double check:

SELECT *
FROM dbc.allrights
WHERE accessright = 'CT'
AND GrantAuthority = 'Y'
AND DatabaseName = 'database where table will be created'
AND UserName = 'database where macro was created'

Dieter
N/A

Re: Access Problem

The problem was that the databasename of the macro and the table getting created were same and this database didn't had access to create table in its own database.

Thanks a lot Dieter for your reply..