[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Locking Out Users
- Subject: RE: [sqr-users] Locking Out Users
- From: "Bencke, Gina" <GinaBencke@forestcity.net>
- Date: Thu, 10 Jun 2004 09:48:28 -0400
- Delivery-date: Thu, 10 Jun 2004 08:50:09 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcRO8U56l5kSEZHvQ2eLChoSJLorcwAAAp/Q
- Thread-topic: [sqr-users] Locking Out Users
Theoretically, any non-SELECT SQL statement can be issued from within a
begin-sql paragraph.
-----Original Message-----
From: sqr-users-bounces+ginabencke=forestcity.net@sqrug.org
[mailto:sqr-users-bounces+ginabencke=forestcity.net@sqrug.org] On Behalf
Of Upstate
Sent: Thursday, June 10, 2004 9:43 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Locking Out Users
By way of SQR, I'm attempting to connect to a databases and lock out
specific users. I'm trying to use, for example: alter user unknown
account lock
alter system kill session
However, I'm receiving invalid commands. Can I use the following
commands above, if so how, or do I need to have this in a script that I
can externally call within SQR?
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users