dbTalk Databases Forums  

Error in dynamic security

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error in dynamic security in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Botinha
 
Posts: n/a

Default Error in dynamic security - 01-13-2004 , 09:56 AM






Hello!

I had implemented dynamic security with security cube plus a virtual
cube.
It works very well when the user exists in the security cube, but when
it doesn't i am reciving this message:

"The query could not be processed:
o Database 'DESPESAS' does not exist."

Or this:
"The query could not be processed:
o Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."

The role i had define are :
"filter([Organização].[Nome].members,
validmeasure(([Measures].[int Permission],[Organização].currentmember,
strtomember(
iif(IsError(strtomember("[Dim_Users].[login].&[" +
mid(username,instr(1,username,"\")+1,len(username) ) + "]")),
"[Dim_Users].&[Unknown]", "[Dim_Users].[Login].&[" +
mid(username,instr(1,username,"\")+1,len(username) ) + "]"))))= 1)"

This errors only happens when i use someone that isn't in my security
cube!
What i am doing wrong?
Its shouldn't returnt a message like: "You don't have permissions to
access data!!"
Please help me!

Thanks in advanced!!

André Fonseca

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.