while a user might be able to see system procedures, they can't do anything with them due to permissions;

it's easy to test, just create a user.

create user ClarkKent without login

execute...

images are blocked at work, but a cross join is pretty easy

SELECT T1. *, T2.*

FROM myTable T1

CROSS JOIN MyTable T2

as Sean alluded to , there's several ways to get the name; you could join to sys.objects, or use the built in functions like object_name:

SELECT OBJECT_SCHEMA_NAME(OBJECT_ID) AS SchemaName,

...

my old shop used it for two reasons; regular expressions for doing ETL on staging tables(no SSIS in that shop...everything is TSQL), and a custom implementation of AES encryption; the...

I don't believe the permissions are that granular; as i understand it, once you grant ALTER, that's ALTER any object.

I believe you can only do by granting ALTER, and then...

performance will ALWAYS suck on this: it requires a table scan due to the LIKE operator, which would have to check every value for values that contain or end with...

now if you want to view the trace results, i like to create a view for each trace: unfortunately, i think it has to have a path variable to be...

paulaalkz 9229 (2/19/2014)

---

Hello. querying sys.traces I found out today that Spotlight Quest is running two rowset traces. I can view the events and columns it is capturing but I wonder...

ownership chaining, and it's the default behavior.

if you grant EXECUTE on a procedure to a user with no other permissions, as long as the stored procedure only touches objects in...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

Original...

this seems to do a nice job:

select sys.schemas.name 'Schema'

, sys.objects.name Object

, sys.database_principals.name username

, sys.database_permissions.type permissions_type

, sys.database_permissions.permission_name

, sys.database_permissions.state permission_state

, sys.database_permissions.state_desc

, state_desc + ' ' + permission_name + ' on ['+ sys.schemas.name...

people get replaced a lot, but their job and permissions are more static. Switch to using roles instead.

there are a ton of scripts on the scripts section to script out...

use the metadata to build a query;

probably featuring a UNION ALL if you want them in a single resutl set

SELECT

'SELECT ' + schema_name(schema_id)+ ' AS SchemaName,* FROM '

...

do you have any plugins like SSMS Tools installed? I can't prove it, but it seems to me that my connections get disconnected when not used for x minutes, and...

if you have users explicitly created without logins, then there's is no password. users don't have passwords, only logins;

I've create users to run EXECUTE AS on occasion, and of...