Viewing 15 posts - 6,136 through 6,150 (of 9,241 total)
granting permissions on the xp worked for me, i suspect the account trying to grant has insufficient permissions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 11:18 am
sporoy (1/6/2012)
yes, the error is :Msg 22001, Level 16, State 1, Line 0
xp_instance_regread() returned error 5, 'Access is denied.'
This works for me
grant execute on object::sys.xp_instance_regread to public
Who are you logged...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 10:32 am
Bernardinho (1/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 6:17 am
farzad.jalali (1/6/2012)
here is where I run the command:C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
run setup from the original install CD\DVD and try launching the command from there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 4:08 am
Please create a new post to get help with any issues.
In regard to this issue what does the following file show
farzad.jalali (1/6/2012)
Please review the summary.txt logs for further details.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 3:36 am
GilaMonster (1/5/2012)
Perry Whittle (1/5/2012)
Granting CONTROL at the schema level is quite brave IMHO 🙂I could use a few other words than 'brave' I think 🙂
😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 5:54 pm
David Moutray (1/5/2012)
Hmmm. It is quite low when I run this process in the dev environment.
Disk and file layouts are bound to be different between dev and live aren't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 1:09 pm
David Moutray (1/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 12:21 pm
ajsnyman (1/5/2012)
To be honest, it seems I do not understand the function of the CONTROL permission.
CONTROL is the highest available within the database. CONTROL implies all other permissions.
Granting CONTROL at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 11:28 am
also, what does this return
select dp.state_desc, dp.permission_name, dp.class_desc, sch.name
from sys.database_permissions dp
inner join sys.schemas sch on dp.grantor_principal_id = sch.principal_id
where dp.class = 3
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 10:39 am
ajsnyman (1/5/2012)
Tried it, then right back to updates and altering ;(
remove the denials and the re run the script below and post the exact results
select dp.name, dbp.state_desc, dbp.permission_name, dbp.class_desc
from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 10:26 am
please check the results of the following query
selectsch.name AS SchemaName
, dp.name AS DBUserName
from sys.schemas sch inner join sys.database_principals dp on
sch.principal_id = dp.principal_id
where dp.name = 'yourdbuser'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 6:21 am
ajsnyman (1/5/2012)
ALTERDATABASEALTERSCHEMA
These are not object level but higher permissions and imply certain other permissions. Does the user own a schema?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 5:52 am
Please return the results of the following queries
check explicit permissions
select dp.name, dbp.state_desc, dbp.permission_name, dbp.class_desc
from sys.database_principals dp inner join sys.database_permissions dbp
on dp.principal_id = dbp.grantee_principal_id
where dp.name = 'yoursqlacct'
Check roles assigned
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 4:05 am
ajsnyman (1/5/2012)
SELECT * FROM fn_my_permissions (NULL, 'DATABASE');
I only get
entity_namesubentity_namepermission_name
databaseCONNECT
databaseSELECT
I had to explicitly deny alter and update on database permissions for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 2:57 am
Viewing 15 posts - 6,136 through 6,150 (of 9,241 total)