Friday, March 23, 2012
Grant access to a single table
Is it possible (or even; is it a good idea...) to create a logon that only has access to a single table?
Actually, I know it's possible - but I don't want to have to go through the hundreds of tables and deny access to them all! So I guess the question is;
Is there a quick and easy way of granting a login permissions to a single table only?Aha! I think I might have cracked it...
Create a new database role and then a new login who can have that role :)
However, the question of "should I do this" still stands.|||Why not?
I don't understand what your concern is.
For a single logon, you could even grant the access directly without bothering with a role.|||Ooh, how do I do that?|||The same way you grant access to a role.
Remember, though, that every login is a member of the PUBLIC role, so you will need to make sure that PUBLIC does NOT have access to any of the objects in the database.|||How did I miss that button before?! Woods and trees, eh.
The public role only has access to sys tables and dt* SPs; I don't have a problem with that.
I just figured this was the easiest and most effective way of implementing security on the FE. This is definately a route I will use again in the future :)
Thanks Blinddudesql
Wednesday, March 21, 2012
Gr
I pass in a field called delivery date
i want the report in 3 sections
Overdue, Today and future
however i am as yet able to find a way to have these 3 logical groupings
thanks frankI need it to know what todays date is.
i did have it working howver for each date it put in the heading|||>>I need it to know what todays date is.
Use currentdate in the formaulasql
Wednesday, March 7, 2012
Go to the last record
Quote:
Originally Posted by LuiePL
How can I go to the last record of database? I've been having problems after creating a new record, and trying to display it, but I don't know what primary ID it's given, so I dont know how to go the last record. Thanks for the help.
if you want to find the last record in a table (with PK = xx) you can to try with:
select * from tabv where xx = (select max(xx) from tab)|||Many thanks!!!!|||Hi,
select top 1 * from tablename order by column name desc
Friday, February 24, 2012
Global Temporary table disappear
used later in coldfusion code. Most of time it works. The coldfusion
will output what's in that global temporary table but sometimes that
global temporary table just disappear in coldfusion and the web page
errors out. I checked the procedure and the global temporary table
does get created. If you have any idea about this, please help!!!!!!!!
I'm stuck here and couldn't do anything about it. Thanks a million!Global temp tables disappear when connections stop referencing them. If the
web site has interrupted connectivity (basically every time you close a
connection, load a new page, etc) then they would not persist. If you are
okay with multiple users of the web site potentially accessing the same
global temp table, why not just use a permanent table? At least that will
only get deleted when you want it to...
A
<mirthcyy@.gmail.com> wrote in message
news:1191867216.347474.55650@.50g2000hsm.googlegroups.com...
>I have a stored procedure creating a global temporary table which is
> used later in coldfusion code. Most of time it works. The coldfusion
> will output what's in that global temporary table but sometimes that
> global temporary table just disappear in coldfusion and the web page
> errors out. I checked the procedure and the global temporary table
> does get created. If you have any idea about this, please help!!!!!!!!
> I'm stuck here and couldn't do anything about it. Thanks a million!
>|||Those global temporary table are report tables. Basically if a user
runs a report, the store procedure will do all the calculations and
put the result into a global temporary table. Then the cold fusion
will return the result from that table. All the reports can be
customized so users will pick different columns and apply different
filters so the report tables will all be different. If we are using
permenant tables, we will create a lot if multiple users are using the
same report and they may be a problem for storage issue. As for
tempdb, it will be cleared on regular basis which is more manageable.
I don't understand coldfusion much so I don't know if they are loading
a new page or not. But I will definitely ask some other developer to
check that.
Sunday, February 19, 2012
Giving roles access to perspectives
In BOL, the page on creating perspectives says
"Dimension and cell security for a perspective are derived from the source cube. However, roles can be given or denied access to a perspective. A role can be denied access to a cube and given access to a perspective of the cube."
However, I can't find out how to grant access to a perspective. There doesn't seem to be anything about it on BOL, and the perspectives don't appear anywhere in the role editor.
Can anybody tell me how to do this? Sorry if I'm being stupid and missing something obvious!
Unfortunately in this version of Analysis Services it is not possible to assign security permission to perspective.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Of cource you can't expect any public commitment to any particular feature :). It has been requested by many customers.
You can create a role object and use BI Dev Studio to grant/deny permissions to dimension members of specific attribute.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.