Viewing 15 posts - 1 through 15 (of 16 total)
Hi Chris,
I've taken a quick look at this and may have something of use.
First off I have a couple of scripts to create the tables and data, presumably you won't...
December 14, 2007 at 5:11 am
Personally I came across a similar issue when I was involved with the transfer of an application from a site in Holland to my office in the UK. It seems...
October 15, 2007 at 10:35 am
Well it looks like the solution is to remove my users from the sysadmins server role.
I only recently added the users to this role, the reason being that I wanted...
September 5, 2007 at 3:39 am
Steve,
thanks for your post. I think it's helped me get a bit closer to finding the source of this problem.
I tried out removing 'malinowm2' from the system administrators group,...
September 5, 2007 at 2:44 am
>>Does the userid 'malinowm2' have database owner permissions on the database? This could be automatically mapping you to 'dbo'.
No, the user has membership of several database roles, 'public', 'fcc_admin',...
September 5, 2007 at 2:36 am
I tried that out and got slightly different results to you. I used a windows account, and also a sql account (malinowm2). My results were the same for both users...
September 4, 2007 at 8:23 am
Yeah that returns 13 as my user_id.
I've tried deleting the user and recreating through enterprise manager, assigning to roles etc., same result though.
Thanks for your help with this by the...
September 4, 2007 at 7:57 am
I saw this article w hile back. Haven't actually tried it but it might be useful for you:
September 4, 2007 at 7:53 am
ok, i've tried this out with a couple of other logins, both of whom are members of the fcc_admin group.
I also get the same results for the 'select user_id() as...
September 4, 2007 at 7:36 am
ok, so i ran these commands:
select user_id() as UID, user_name() as Uname
select suser_sname() as SUname
go
select is_member('fcc_admin') as [is_member]
go
sp_helprolemember @rolename = 'fcc_admin'
and this is what i got in my results pane:
UID ...
September 4, 2007 at 4:53 am
looks like the image isn't showing so here is what I see in query analyzer (I am logged in as user malinowm2)
query pane :
select is_member('fcc_admin') as [is_member]
go
sp_helprolemember @rolename = 'fcc_admin'
results...
September 4, 2007 at 4:26 am
Hi,
I tried using sp_helprolemember, and it shows my user id as being in the role, however is_member is still not working.
September 4, 2007 at 4:23 am
iwg,
First off I was slightly wrong earlier, our indexed columns are query id (fk to another table), company id, dealer id, person id and company name.
in answer to your questions:
>Do you...
May 25, 2007 at 9:26 am
Ed, iwg,
first off thanks for your responses.
Personally I was thinking that a clustered index might not be particularly appropriate given the way the this table is used, but it's always...
May 25, 2007 at 7:12 am
thanks for the help on this!
I think the way to go is dynamic sql (why didn't I think of that!). This has uncovered a couple of issues with user permissions...
April 12, 2007 at 10:15 am
Viewing 15 posts - 1 through 15 (of 16 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy